Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
If you are using Qlikview 11 then you can use Dimension Limits to restrict top n values.
Regards,
Jagan.
To add I am using QV10.