Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank in Ascending order

Hi,

I have a straight table chart with a simple Rank function that goes like this: =Rank([Expression]). This works fine. It ranks Descending. How can I get it to rank Ascending?

Thanks

1 Solution

Accepted Solutions
maneshkhottcpl
Partner
Partner

Hi,

Please refer the attached application. u can use the -(minus) sign in rank function.

View solution in original post

4 Replies
Not applicable
Author

Use the same expression in sort order.

Not applicable
Author

I think I should have explained better. What I have is expressions, ranking the previous expression. Example is

Expression 1 Expression 2

Rank([Expression 1])

4 2

6 1

3 3

2 4

Expression 2 is ranking in Descending order. I can't use the Sort Tab to achieve this because I have 8 expressions like 'Expression 1' and 8 expressions that rank these expressions. This is all in one table. Is there a way to rank in Descending in the expression?

maneshkhottcpl
Partner
Partner

Hi,

Please refer the attached application. u can use the -(minus) sign in rank function.

View solution in original post

Not applicable
Author

Thanks Manesh, does just what I wanted.