Discussion board where members can get started with QlikView.
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:
In any single chart create the three variables
For Top 10
For Top 5
and one inline table for selection, after all this conditionally load the expressions for more see the sttached
Hello Vijaya ,
First Create buckets of Top 10 ,Top 5 and All value in Backend Script by Using nested If
if(aggr(rank(sum(Sales)),State)>10,'ALL-Value'))) as TOP
Then take TOP Field as FilterPlane / ListBox
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.