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: 
suvechha_b
Creator III
Creator III

How to sort on some expression

How can I sort the below report regarding the expression ,

For eg,

My requirement is Highest variance will come first and then so on.

Capture.PNG

4 Replies
Chanty4u
MVP
MVP

use

FirstStoredValue(Dim,-Value)

jonathandienst
Partner - Champion III
Partner - Champion III

You will need a custom sort expression for the dimensions if your table is a pivot (which it appears to be).

Your sample document is rather large, I suggest that you reduce it to make it easier to download and analyse.

Preparing examples for Upload - Reduction and Data Scrambling

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
suvechha_b
Creator III
Creator III
Author

PFA.

Sample model attached.