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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort based on values

Hi All,

  I am having following scenario.

1 . When I Click "Id" I need to sort based on "Sort" column

2. When I "Clear All" still I need to have the sort order column dimension followed by non "Id" Values

All I need is irrespective of the "Id" qlik I need to sort based on sort column followed by non "Id values.

Kindly let me know if any queries

-Jay

1 Reply
swuehl
MVP
MVP

Maybe using a sort expression like

If(GetSelectedCount(Id),min(Sort),Rangesum(Min({<Id = {Y}>}Sort),Only({<Id = E({<Id = {Y}>}) >} Ord(lower(Rules)))))