Solved: How to assign same number to duplicate values in a... - Qlik Community

Anonymous · ‎2019-10-01

Hi, consider the data given below

Bill

Clive

Mary

John

Lily

How do i assign same number to the duplicates so that the output looks like this;

1 Bill

2 Clive

3 Mary

4 John

5 Lily

manodwhb · ‎2019-10-01

@ahmed_analytics ;check the below one.

TRF · ‎2019-10-01

Have a look to tAggregateRow

manodwhb · ‎2019-10-01

@ahmed_analytics ,check the below solution.

Anonymous · ‎2019-10-01

can you please elaborate on how to use taggregate row

Anonymous · ‎2019-10-01

What if the duplicates are not in order ?

example:

Bill

Clive

Bill

Mary

Bill

Clive

Mary

then it still should be

1 Bill

2 Clive

1 Bill

3 Mary

1 Bill

2 Clive

3 Mary

manodwhb · ‎2019-10-01

@ahmed_analytics ;check the below one.

TRF · ‎2019-10-01

@ahmed_analytics, forget tAggregateRow in this case

Anonymous · ‎2019-10-02

Thanks @manodwhb , sorting the rows first did the trick.

How to assign same number to duplicate values in a column