RowNo(), Rank(), RangeCount(Above) ?

[carol_wu]

Hi experts,

Here, I want to generate Row No if they share the same Code, User Cd and Day Number, but failed. I have tried to use aggr, also failed. Are you have any recommendations?

Thanks!

[mikaelsc]

autonumber(Code & '|' & User Cd &'|' & Day Number,'WhateverNameYouGivetoyourAutoNumberIndex') as MyNewField

the same combination of Code, User Cd and Day Number will give the sale MyNewField (numeric) value

[carol_wu]

Because I can't modify the data model, so is there any other good ideas?

[mikaelsc]

do the same in the frontend (visualisations)

add "=autonumber(Code & '|' & User Cd &'|' & Day Number,'WhateverNameYouGivetoyourAutoNumberIndex')"

in the dimension.

[carol_wu]

In QlikSense frontend, there is no function named autonumber, autonumber can't work in the frontend.

[mikaelsc]

true, sorry... hash? but that doesn't give a number...