Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
jagjivvt
Contributor

How to best to handle duplicate relation key

Hi

I am looking for best way to handle duplicate keys. i am currently using the peek function that notes the first instance with and 1 and then adds a 1 to each duplicate record.

if(DSG_EEIDWE = Peek('DSG_EEIDWE'), Peek('DSG_EEIDWECTDSG')+1,1)as DSG_EEIDWECTDSG,

     if(DSG_EEIDWE = Peek('DSG_EEIDWE'), Peek('DSG_EEIDWECTDSG')+1,1)&DSG_EEIDWE as DSG_EEIDWE2

is there another way in QlikView to work this out.

thanks

Vijay

1 Reply
Highlighted
narenjln
Contributor

Re: How to best to handle duplicate relation key

Hi ,

If you having duplicate column in Key Column means you can use the Rowno() function to make the duplicate records unique in case that's what you are looking for.

Or Else

Kindly attach the sample record so that we can able to understand what you really looking for