Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanand3535
Contributor

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
MVP
MVP

Re: How to sort values of measure

Is this a dimension or expression?

vanand3535
Contributor

Re: How to sort values of measure

it's a measure

and measure calculated by expresion

MVP
MVP

Re: How to sort values of measure

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

vanand3535
Contributor

Re: How to sort values of measure

it's measured in a pivot table.

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

MVP
MVP

Re: How to sort values of measure

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

hacr-sds
Contributor

Re: How to sort values of measure

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)

Community Browser