Edit dimension value shown

[#1]

Hi everybody,

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

Best regards

Nicolò Cogno

[aarkay29]

May be

Autonumber(Key)

[#3]

HI,

thanks, but that doesn't work because I have this situation

6705	...	20
6705	...	21
6705	...	22
6705	...	23
6705		24
6705		25
6705		26
6706		1
6706		2
6706		3
6706		4
6706		5
6706		6
6706		7

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?

[rupamjyotidas]

Maybe use RowNo() in script

Load *,  RowNo( ) from Tab1.csv

[aarkay29]

can you post some sample data, how you have and how you want it to be

Thanks,

Aar

[#6]

rupamjyotidas‌ and aarkay29‌ maybe I'm just searching for the wrong thing.

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?

[rupamjyotidas]

Are you trying to do it in Front end. Or in Script.

In Front End you may have to aggr to get the values

Aggr(Value,Key)

in Script: Why do you want to ignore the key.

[#8]

I'm trying with the Aggr(Value,Key), but if don't insert the key field into the table as a column I don't get all the rows

[rupamjyotidas]

Can you share in excel your data and the table you are tying to make

[#10]

I'm sorry, but I can't share my data