topic Re: Re: Re: Filtering dimensions based on Slider value in QlikView

Filtering dimensions based on Slider value

Wed, 18 Sep 2013 08:51:02 GMT

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?

Re: Filtering dimensions based on Slider value

israrkhan — Wed, 18 Sep 2013 08:56:47 GMT

I think you can do it by conditional dimensions,

check conditional and put condition like below for dimension

if($(Sale)=10)

hope it help..

Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 09:04:12 GMT

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

Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 09:46:44 GMT

Hi,

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

Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 11:06:30 GMT

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?

Re: Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 11:40:40 GMT

Hi Sagar,

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

Regards,

Nitesh

Re: Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 11:58:02 GMT

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.

Re: Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 12:06:15 GMT

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

Re: Re: Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 12:17:35 GMT

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

Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 12:22:00 GMT

Hi Sagar,

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

Regards,

Nitesh

Re: Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 12:28:20 GMT

Hi Nitesh,

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

Re: Re: Re: Filtering dimensions based on Slider value

Wed, 18 Sep 2013 12:42:13 GMT

mmmm something like this? (see attached file)