Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MayilVahanan

Hi

  I think attached file helps you.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.