Using Buttons For a Straight Table in Qlikview

[oliveton]

I have a straight table with some sales data, which is ranked from smallest to largest. 

I want to use the button to select only the 20 lowest numbers. 

How do I go about doing this? 

Thanks 

[jwjackso]

Quick and dirty.  Create a variable.

SET vRankData=0;

In the button, set an action to change the vRankData, =If(vRankData = 0,1,0).  This will toggle the value.  You can use this variable to change the button text.

Duplicate the table, position the tables on top of each other.  In one table in the "Dimension Limits", set to show only the smallest 20 items (let Qlik do the work).  On the "Layout"->Show->Conditional put the vRankData.  On the original table, On the "Layout"->Show->Conditional put =1-vRankData

[Brett_Bleess]

Check out the following two Design Blog posts, I think they may give you another option possibly.

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

Regards,
Brett