Using Slider to narrow down the data size

[#1]

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

[#2]

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

[#3]

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.