topic How to show all duplicates with help of Rowno() in QlikView

How to show all duplicates with help of Rowno()

kurakuaa — Thu, 01 Feb 2018 06:11:29 GMT

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‌

Re: How to show all duplicates with help of Rowno()

sunny_talwar — Thu, 01 Feb 2018 17:50:29 GMT

You can create RowNo like this

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

Re: How to show all duplicates with help of Rowno()

kurakuaa — Fri, 02 Feb 2018 06:14:24 GMT

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

Re: How to show all duplicates with help of Rowno()

sunny_talwar — Fri, 02 Feb 2018 16:42:49 GMT

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

];