topic Re: Unable to sort Ukey in QlikView

Unable to sort Ukey

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hello All

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

Re: Unable to sort Ukey

prma7799 — Thu, 08 Mar 2018 06:42:43 GMT

It is sorted properly just promote you Ukey to above position and check ...

Re: Unable to sort Ukey

prma7799 — Thu, 08 Mar 2018 06:43:45 GMT

Check this

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 07:17:46 GMT

Thanks ,

Please kindly let me know how to Flag =1 when occurance is one . Highlight in red .

But zero where occurance is twice , say 849 compare previous row 849 then flag 0.

Thanks in advance.

Re: Unable to sort Ukey

prma7799 — Thu, 08 Mar 2018 07:24:41 GMT

Try this

Load

If(Count(previ....)>1,0,1) as Flag

from table

Group by fields;

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 08:01:12 GMT

Hello P M ,

the count and group by is not working

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 08:10:24 GMT

Hello P M ,

the count and group by is not working

sample attached.

Re: Unable to sort Ukey

prma7799 — Thu, 08 Mar 2018 08:59:28 GMT

what error you are facing?

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 09:05:31 GMT

I am getting Flag as all 0. please kindly see the sample model.

Re: Unable to sort Ukey

prma7799 — Thu, 08 Mar 2018 09:16:47 GMT

Try this

OpenUser_final3":

NoConcatenate

LOAD

DateJoinKeyPL,

deal1,

dealnm1,

previousdealid,

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

Resident "OpenUser_final2"

GROUP BY DateJoinKeyPL,

deal1,

dealnm1,

previousdealid;

Or please share some sample data ....

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 09:56:29 GMT

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 .

Re: Unable to sort Ukey

prma7799 — Thu, 08 Mar 2018 10:08:07 GMT

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.

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 10:18:24 GMT

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.

Re: Unable to sort Ukey

suvechha_b — Thu, 08 Mar 2018 10:32:55 GMT

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