3 Replies Latest reply on Sep 22, 2016 2:42 AM by abhishek bagewadikar

# How to get automatic mark in tableau(for eg.If i select less than 20 then values less than 10 also needs to be displayed...)

Please tell me as early as possible

• ###### 1. Re: How to get automatic mark in tableau(for eg.If i select less than 20 then values less than 10 also needs to be displayed...)

Could you please attach the workbook in .twbx format?

However till then you can write an IF..ELSE..END statement like that

IF [Value]<20 THEN 1 ELSE 0 END

You can use this as quick filter. You can write your own condition.

Mahfooj

• ###### 2. Re: How to get automatic mark in tableau(for eg.If i select less than 20 then values less than 10 also needs to be displayed...)

One way would be a parameter and a calculated filed.

I attached a workbook, but i dont know if you'll be able to open it, so here are steps.

Step 1.

Create a parameter with the groupings you want.

Step 2.

Create a calculated field based on this parameter that will serve as your filter.

Step 3.

Put that calculated field in the filters and set it to 1.

• ###### 3. Re: How to get automatic mark in tableau(for eg.If i select less than 20 then values less than 10 also needs to be displayed...)

CASE [ForAll]

WHEN "<10" THEN

IF([Bucket]="0 to 10") THEN 1 ELSE 0 end

WHEN ">10" THEN

IF([Bucket]="10 to 20" OR [Bucket]="G 20") THEN 1 ELSE 0 end

WHEN "<20" THEN

IF([Bucket]="0 to 10" OR [Bucket]="10 to 20") THEN 1 ELSE 0 end

WHEN "all" THEN

IF([Bucket]="0 to 10" OR [Bucket]="10 to 20" OR [Bucket]="G 20") THEN 1 ELSE 0 end

WHEN "=20" THEN

IF([Bucket]="G 20") THEN 1 ELSE 0

END

END=1