Filtering dimensions based on Slider value

[#1]

Hi All,

I have created a variable and then created a slider that changes this variable. The range of the variable is 0% to 100%.

Now, I have a dataset as follows and I want to show those dimensions for this %Sales column matches with the slider value.

Customer	Sales	% Sales
A	-10	10%
B	-20	20%
C	-30	30%
D	-40	40%

For example, if the slider is selected at 40%, I want to filter the above table to show only Customer D. Is this doable?

[israrkhan]

I think you can do it by conditional dimensions,

check conditional and put condition like below for dimension

if($(Sale)=10)

hope it help..

[#3]

Hi!

I would use a calculated dimension instead of "Customer"

example:

if(%SalesExpr = $(YourVar), Customer)

and flag "Suppress When Value Is Null" on this dimension

[#4]

Hi,

I have used triggers on variable and used the calculated dimension. See the attachment.

[#5]

Thanks Venu and Francesco. I would have tried exactly the same, but my %Sales Expression is a relative field. I am unable to use that expression in my dimension. I hope I am able to understand.

Customer	Sales	% Sales (I have selected Relative checkbox to get this value)
A	-10	10%
B	-20	20%
C	-30	30%
D	-40	40%

Can you help further?

[#6]

Hi Sagar,

Please check the attached... Hope it would suffice your requirement.

Regards,

Nitesh

[#7]

Nitesh, thanks for your effort but this doesnt work for me because you have assumed that %Sales is a field that I am using, while it is a Relative Expression in my straight table.

[#8]

have you tried to transform the number in the if statement? Can you attach an example of your straight table ?

[#9]

Hi Francesco,

I am attaching a sample of exactly what I plan to achieve. I would want the straight table to show the data only for the value selected in the slider. Looking forward to your response.

Thanks,

Sagar

[#10]

Hi Sagar,

Could you please elaborate the problem statement a bit more...

Regards,

Nitesh