Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am trying rank function in Qlik sense for below mentioned table
ProductData:
Load * inline [
Customer|Product|UnitSales|UnitPrice
Astrida|AA|4|16
Astrida|AA|10|15
Astrida|BB|9|9
Betacab|BB|5|10
Betacab|CC|2|20
Betacab|DD|0|25
Canutility|AA|8|15
Canutility|CC|0|19
] (delimiter is '|');
In result it is sorting internally within the customer column and not overall.
Find below the snap shot of result.
Request you to please help...
The Rank function depends on the dimension your sorting it into.
As an example, with your data and getting some Rank functions, I get the below image where:
Red table: Sorted by Customer
Orange table: Sorted by product
So it gives different results based on which dimension is being sorted first.