Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

adding sufixes

hi,

i have few values in list box as below:

Names
India
Bangalore
Cochin
India

Hyderabad

Pune
Mumbai
Pune
Mumbai

as seen in the list box, there are duplicates like india, pune and mumbai so i need only these three names to be suffixed by India_S, Pune_S, and Mumbai_S

so my list box will be like this :

Names
India
Bangalore
Cochin

India_S

Hyderabad
Pune
Mumbai
Pune_S
Mumbai_S

please help

Regards

srujana

10 Replies
MarcoWedel

Hi,

maybe like this:

QlikCommunity_Thread_243075_Pic2.JPG

QlikCommunity_Thread_243075_Pic3.JPG

=Aggr(Names&If(RowNo()>1,'_S'),Names,ID)

hope this helps

regards

Marco