I made a table in which some rows are identical and the only way to show them all is to add a dimension as the first column of the table that contains the unique key. This dimension is a progressive number, but it never starts from 1 (with the selections that I made, for example, I've got numbers from 20 to 48).
Is it possible to replace those numbers with something like the row number? I need a progressive number that starts from 1
Thanks a lot for your help and for your attention
thanks, but that doesn't work because I have this situation
So I have repeated numbers, I think I need something like a dynamic mapping that use my dimension to order all the columns, but has row number values instead.
Do you think this is possible?
I've got a table that contains identical rows, but in my data the values differ for a key. If I don't add the key dimension Qlik Sense aggregate the rows and I can't see all the data, would it be possible to show all the data without the key column?
Are you trying to do it in Front end. Or in Script.
In Front End you may have to aggr to get the values
in Script: Why do you want to ignore the key.