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

Row numbering by two dimension

Hello all,

I have a problem when I put RowNo to the straight table, ordering by field changed. Idea to get in result the following:

#
A
B
Value
1AADD687
2BBDD566
3AASS345
4GGDD111

Thanks in advance!

16 Replies
Not applicable
Author

The result now:

A
BValueAlt(Above(Column(2))+1, 1)
AASS3451
BBDD6872
BBDD5663
GGDD1114

And it is not correct, Value field should be ordered as descend.

Correct result shoud be as

customRowNoABValue
1AADD687
2BBDD566
3AASS345
4GGDD111
jonathandienst
Partner - Champion III
Partner - Champion III

Then sort the table by Value and drag the row no to the left.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Sorry, but it doesn't work.

jonathandienst
Partner - Champion III
Partner - Champion III

You can try this:

Rank(Total Aggr(Sum(Value), A, B))

See the attached. However, if you reverse the sort of value, the count will reverse as well.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks a lot Jonathan, it works perfectly!!!

Not applicable
Author


Hi JOnathan,

Thanks for this.

Can you please let me know how can I get Rank in Reverse Order for the descending Sorted values?

Thanks in Advance

Regards,

Susvith

Not applicable
Author

something like that:

Rank(Total Aggr(Sum(Value)*-1, A, B))