Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

nagarjuna123
New Contributor II

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
New Contributor III

Re: How to get Sorting in Rank?

Hello,

try this,

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

nagarjuna123
New Contributor II

Re: How to get Sorting in Rank?

HI Shinde,

But here Rank is calculated dimension.

ashwinishinde
New Contributor III

Re: How to get Sorting in Rank?

hello,

try this,

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


Rank.png

Community Browser