Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a straight table which has City name as dimmenssion and some expressions( one of which is Quarter1 Net Sales),
Now I have an list box which displays (5,10,15, All records)......If I select 5 from this list box then there is a varriable which will return the value as 5
If I select 10 from this list box then there is a varriable which will return the value as 10.. and so on.
And in dimmenssion limit I have marked Largest and in place of value I gave the above mentioned Varriable.
Now If I select 5 from list box then: I want the top 5 values in the table based on my Quarter1 Net Sales in Descending order and so on.......
I tried a lot but couldn't find any solution, Plz plz help me out
I think attached file helps you.