topic Re: Using Buttons For a Straight Table in Qlikview in QlikView

Using Buttons For a Straight Table in Qlikview

oliveton — Sat, 16 Nov 2024 01:21:09 GMT

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

Re: Using Buttons For a Straight Table in Qlikview

jwjackso — Tue, 04 Feb 2020 23:21:52 GMT

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

Re: Using Buttons For a Straight Table in Qlikview

Brett_Bleess — Wed, 04 Mar 2020 21:03:32 GMT

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