Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
Creator III

How to sort values of measure

I have calculated  % for particular filed in measure and got around 20 % values.

But these values are not in order  like 5%,1%,70%,30%

I want to display % values of the measure in order like 1%,2%,3%...

how can i sort the measure values?

6 Replies
sunny_talwar

Is this a dimension or expression?

vanand3535
Creator III
Creator III
Author

it's a measure

and measure calculated by expresion

sunny_talwar

So, you are unable to sort by measure? Can you share an image of the sorting order for dimensions and expressions?

vanand3535
Creator III
Creator III
Author

it's measured in a pivot table.

In sorting section, I'm not getting a measure values only rows and columns fields are displaying

sunny_talwar

oh okay... make sense.. would you be able to share a sample to see and test out?

hacr
Creator
Creator

What happens if you use the "Sort by expression" and put in your measure expression (I think this is what you look far, as far as I understand)? As Sunny point out, please post a sample to test

Furthermore... take a look at this topic Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)