Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sorting of Table is not working properly...

Hi,

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

Regards

Sagar Gupta

1 Reply

Re: Sorting of Table is not working properly...

Hi

  I think attached file helps you.

Community Browser