Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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