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: 
Anonymous
Not applicable

How to get Sorting in Rank?

Hi Experts,

I have Rank Id 's in Calculated dimension in Pivot table .

How to get Rank wise sorting in Dimension level

Rank:

12

32

45

1

344

excapted out put is

Rank

1

12

32

45

344

3 Replies
ashwinishinde
Partner - Contributor III
Partner - Contributor III

Hello,

try this,

Properties -->Sort --> Expression --> =rank(Rank)

Anonymous
Not applicable
Author

HI Shinde,

But here Rank is calculated dimension.

ashwinishinde
Partner - Contributor III
Partner - Contributor III

hello,

try this,

try same expression =rank(Rank)  for first dimension of pivot table.


Rank.png