How to show all duplicates with help of Rowno()

[kurakuaa]

Hi All,

I am facing some  issue in showing all duplicates in list box. So I need some help for my below input.

ID	Name
1	A
2	A
3	A
4	A
5	B
6	C
7	D
8	D
9	E

In the above input ID I will not be using anymore in qlikview. Now I need to show all the Name column vales in List box without distincting. So if I get below output with help of row no then I will be writing logic based on row no for incrementing spaces in Name column for each name. So I need below as output

ID	Name	Row no
1	A	1
2	A	2
3	A	3
4	A	4
5	B	1
6	C	1
7	D	1
8	D	2
9	E	1

Many thanks in advance

Thanks,

Avinash   jagan‌  bpn‌  qlik_dev_new‌

[sunny_talwar · Accepted solution]

You can create RowNo like this

AutoNumber(RowNo(), Name) as [Row no]

[kurakuaa]

Hi Sunny,

Many thanks for your reply.

Right now I am hardcoding like if row number is 1 then Name&' ', if row number is 2 the Name&'  '(two spaces) like that. So is there any dynamically incrementing the spaces based on row number like that.

I need your help on this dynamically incrementing the spaces.

Thanks in advance.

Thanks,

Avinash kuraku

[sunny_talwar]

Try this

Table:

LOAD *,

Name & Repeat(' ', AutoNumber(RowNo(), Name)) as New_Name;

LOAD * INLINE [

    ID, Name

    1, A

    2, A

    3, A

    4, A

    5, B

    6, C

    7, D

    8, D

    9, E

];