Discussion Board for collaboration related to QlikView App Development.
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.
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.
Kindly attach the sample record so that we can able to understand what you really looking for