Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kurakuaa
Contributor
Contributor

How to show all duplicates with help of Rowno()

Hi All,

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

IDName

1

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

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

IDNameRow no
1A1
2A2
3A3
4A4
5B1
6C1
7D1
8D2
9E1

Many thanks in advance

Thanks,

Avinash   jagan‌  bpn‌  qlik_dev_new

1 Solution

Accepted Solutions
sunny_talwar

You can create RowNo like this

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

View solution in original post

3 Replies
sunny_talwar

You can create RowNo like this

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

kurakuaa
Contributor
Contributor
Author

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

];


Capture.PNG