Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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