topic Using Slider to narrow down the data size in QlikView

Using Slider to narrow down the data size

Thu, 10 Dec 2009 21:24:21 GMT

Hi everyone,

I am do some calculations and results in few types of data:

1. Ranking due to store monthly performance;

2. score of management efficiency;

3. Month turnover

etc

How can I use the slider to reduce the store numbers for review? e.g. a slider from 1 to 100 percent for the Rank. If I make it become 10(slide the pointer to 10), then qlikview will show the top 10% in the Rank.

Many thanks

Ivan

Using Slider to narrow down the data size

Thu, 21 Oct 2010 16:20:29 GMT

I am also trying to do this but just cant get it to work. I have a slider with 1 - 100 which populates a variable varPercentage. I want to restrict a pivot table to show only deals where Prob_of_Win >= varPercentage

Prob_of_Win field is in %age

Anyone got any ideas, I have tried all the normal restriction filed but it just cant get it to work.

Thanks in advance

Alan

Using Slider to narrow down the data size

Thu, 21 Oct 2010 19:51:39 GMT

I was thinking about Set Analysis, but it doesn't seem like you want to aggregate anything. How about an if statement?

You can add a calculated dimension: =if(Prob_of_Win >= varPercentage, Dimension_Field_Name, null())

Make sure to label it so it doesn't get named by the calculation, and also suppress values that are null.