Unable to sort Ukey

[suvechha_b]

Hello  All

I am unable to sort the Ukey field ..please assist. samplemodel attached.

[suvechha_b]

HI PM,

Its still not working ,

I did some change and create UniqueKey (UK) with the Date and previousdealid .

and tried your script .

"OpenUser_final4":

NoConcatenate

LOAD

UK,

DateJoinKeyPL, 

  deal1, 

    dealnm1, 

    previousdealid,

if(count(UK)>1,0,1) as FlagLateststate

Resident "OpenUser_final3"

GROUP BY UK,

DateJoinKeyPL, 

  deal1, 

    dealnm1, 

    previousdealid;

But still not Flag is correct . Sample model attached. Please kindly assist.

See the outcome table .

[prma7799]

On which field you want to do Flag ...

OpenUser_final3":

NoConcatenate

LOAD

DateJoinKeyPL,

  deal1,

     dealnm1,

     previousdealid,

if(count(previkey)>1,1,0) as FlagLateststate

Resident "OpenUser_final2"

GROUP BY DateJoinKeyPL,

  deal1,

     dealnm1,   

     previousdealid;

please share sample qvd.

[suvechha_b]

I did provide you sample model.

Is there any way to compare the value of same field by previous ()

if values match with the previous then flag 0 else 1.

[suvechha_b]

Count is not working as because qlikview is treating the two highlighted row as two different rows . Which is not correct to my requriement.