Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Edit dimension value shown

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

11 Replies
aarkay29
Valued Contributor

Re: Edit dimension value shown

May be

Autonumber(Key)

Not applicable

Re: Edit dimension value shown

HI,

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

6705...20
6705...21
6705...22
6705...23
6705

24

670525
670526
67061
67062
67063
67064
67065
67066
67067

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
Valued Contributor

Re: Edit dimension value shown

Maybe use RowNo() in script

Load *,  RowNo( ) from Tab1.csv

aarkay29
Valued Contributor

Re: Edit dimension value shown

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

Thanks,

Aar

Not applicable

Re: Edit dimension value shown

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
Valued Contributor

Re: Edit dimension value shown

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.

Not applicable

Re: Edit dimension value shown

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
Valued Contributor

Re: Edit dimension value shown

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

Not applicable

Re: Edit dimension value shown

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