topic Re: Top 5,10 values in list box in QlikView

Top 5,10 values in list box

kvr9 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to create a list box which gives an option of selecting Top 5,Top 10 and All values.

Can someone help me what the logic to create.

My data is in below format:

Load

Country,

State,

Sales

from

abc .table;

Re: Top 5,10 values in list box

krishnacbe — Mon, 09 Oct 2017 14:45:07 GMT

Hi,

Hope the attached file will help.

Re: Top 5,10 values in list box

its_anandrjs — Mon, 09 Oct 2017 15:40:48 GMT

In any single chart create the three variables

For Top 10

=if(aggr(rank(sum(Sales)),States)<=10,sum(Sales))

For Top 5

=if(aggr(rank(sum(Sales)),States)<=5,sum(Sales))

all Values

Sum(Sales)

and one inline table for selection, after all this conditionally load the expressions for more see the sttached

Re: Top 5,10 values in list box

kvr9 — Tue, 10 Oct 2017 07:17:19 GMT

Thanks a lot, it works.

Re: Top 5,10 values in list box

vikasdesai — Tue, 10 Oct 2017 10:25:39 GMT

Hello Vijaya ,

First Create buckets of Top 10 ,Top 5 and All value in Backend Script by Using nested If

i.e If(aggr(rank(sum(Sales)),State)<=10,'TOP-10',

if(aggr(rank(sum(Sales)),State)<=5,'TOP-5',

if(aggr(rank(sum(Sales)),State)>10,'ALL-Value'))) as TOP

Then take TOP Field as FilterPlane / ListBox

Re: Top 5,10 values in list box

krishnacbe — Tue, 10 Oct 2017 12:57:17 GMT

Good to hear. Please close the thread by marking the helpful/ Correct answer.

Re: Top 5,10 values in list box

its_anandrjs — Tue, 10 Oct 2017 14:11:44 GMT

It seems you got the answers from the thread may be close the thread with appropriate answers.

Re: Top 5,10 values in list box

kvr9 — Wed, 11 Oct 2017 07:08:06 GMT

Hi Vikas,

Can you please share an example with above script.

Re: Top 5,10 values in list box

kvr9 — Wed, 11 Oct 2017 07:11:09 GMT

Hi Anand,

It works for single table,but I want this to be applicable for all charts and tables in my dashboard.

So should I write this expression in all charts?

Could please advice me how to work on it.

Re: Top 5,10 values in list box

vikasdesai — Wed, 11 Oct 2017 09:05:09 GMT

Hi Vijaya

Can u Please share the DataFile

Re: Top 5,10 values in list box

its_anandrjs — Wed, 11 Oct 2017 09:39:36 GMT

Thanks Yes exactly you have to copy and paste all the expression that you required. And you can go for creating another chart as well as if you required.

Re: Top 5,10 values in list box

Max — Thu, 30 Jan 2020 11:38:23 GMT

Thanks ! Helped me tons 😄