topic Re: Filter by on expression in QlikView

Filter by on expression

Sat, 01 Feb 2014 21:58:31 GMT

I have a single chart as this one:

Customer A **************** 35 %

Customer B ************** 30 %

Customer C ******** 10 %

Customer D ***** 7 %

...

PCT Discount expression is some thing like sum( discount ) / ( sum( price ) + sum( discount ) )

At this time, I want to filter chart to see only clients with a PCT Discount < X. How can I create a slider object to select X ?

This is my first question. Sorry if I have contravened any etiquette rule.

martin59 — Sat, 01 Feb 2014 23:47:48 GMT

Hi Daniel,

First, if you want to use a slider object, you must create a variable.

So, go to Settings / Variable overview and add a new variable called vLimit.

After that, you have to create a new "Slider / Calendar object".

Let the input type as slider, choose your variable and set the options like in the picture.

Hope that helps you,

Martin Favier

Sun, 02 Feb 2014 09:34:34 GMT

Thanks Martin,

runs like a charm:

Also important to set limit to var in chart limits dimension properties:

daniel.