Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button - top10 , top20 , clear / show all

Hi

I have created two buttons 'top10' and 'top20' both with actions of 'set variable'. The variable is populated with 'vTop' and values '10' and '20' respectively. I have set my straight table presentation tab , max number option to '=vTop'.  These two buttons work fine. I have a third button called 'show all' again the action is 'set variable' , variable is populated as 'vTop' and value as blank. I have tried 999999 , * , space but I'm guessing that it is limited to 100 lines....?

Is there another method which will give me what I require?

-Show all lines

-option to filter by top10 or either top20 lines

-filter back to show all lines

Cheers.

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

If you are using Qlikview 11 then you can use Dimension Limits to restrict top n values.

Regards,

Jagan.

Not applicable
Author

To add I am using QV10.