topic Re: ListBox with Top N values in QlikView

ListBox with Top N values

pradnyat — Fri, 04 Jul 2014 10:25:36 GMT

Hello All,

I have one listbox with the inline fields : 5,10,15,All.

If user selects 5 then I want to change the chart with top 5 sales and like that.

I am using this field name in Dimension limits option. This is working fine for 5,10,15.

But I want the functionality like if user selects All, then it should display all the data, but its not working.

Can anybody help me with this.

Thanks in advance...!

Re: ListBox with Top N values

Gysbert_Wassenaar — Fri, 04 Jul 2014 11:09:28 GMT

Try rangemin(only(MyListboxField), 9999999)

Re: ListBox with Top N values

pradnyat — Fri, 04 Jul 2014 11:45:25 GMT

Hi Gysbert,

I don't want to directly give the maximum value 9999999. Is there any other way that we can use some function to find out the number of rows in output and give that value there.

Re: ListBox with Top N values

tresB — Fri, 04 Jul 2014 11:49:33 GMT

Yes you can use something like:

=rangemin(only(MyListboxField), Count( Distinct <YourFieldInDimension>)+1 )

Re: ListBox with Top N values

Gysbert_Wassenaar — Fri, 04 Jul 2014 11:52:29 GMT

Why not? Surely you don't intend to show 10 million rows in your chart?

Re: ListBox with Top N values

VishalWaghole — Fri, 04 Jul 2014 12:00:49 GMT

Hi Pradnya,

PFA and try this,

=rangemin(only(ListboxField), Count( Distinct <Dimension>)+1 )

Hope it will work for you.

- Regards,

Vishal Waghole