Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
pradnyat
Creator
Creator

ListBox with Top N values

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...!

1 Solution

Accepted Solutions
VishalWaghole
Specialist II
Specialist II

Hi Pradnya,

PFA and try this,

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

Hope it will work for you.

- Regards,

Vishal Waghole

View solution in original post

5 Replies
Gysbert_Wassenaar

Try rangemin(only(MyListboxField), 9999999)


talk is cheap, supply exceeds demand
pradnyat
Creator
Creator
Author

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.

tresesco
MVP
MVP

Yes you can use something like:

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
VishalWaghole
Specialist II
Specialist II

Hi Pradnya,

PFA and try this,

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

Hope it will work for you.

- Regards,

Vishal Waghole

View solution in original post