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?
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
Because I can't modify the data model, so is there any other good ideas?
do the same in the frontend (visualisations)
add "=autonumber(Code & '|' & User Cd &'|' & Day Number,'WhateverNameYouGivetoyourAutoNumberIndex')"
in the dimension.
In QlikSense frontend, there is no function named autonumber, autonumber can't work in the frontend.
true, sorry... hash? but that doesn't give a number...
Retrieving data ...