topic Re: flag in QlikView

flag

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

Hi all

i want to create flag like

if D.no has Staus= H , S and Tx is same for Both H,S and if rank is same , How can i acheive this in backend ?

Re: flag

subbareddykm — Thu, 31 Mar 2016 15:56:56 GMT

Hi , Can any one tell me how to achieve this ?

Re: flag

MarcoWedel — Thu, 31 Mar 2016 15:59:36 GMT

Please post example values and expected flag results.

Regards

Marco

Re: flag

subbareddykm — Thu, 31 Mar 2016 16:09:37 GMT

Re: flag

swuehl — Thu, 31 Mar 2016 16:10:52 GMT

Maybe like this?

TMP:
LEFT JOIN (Sheet1$)
LOAD D.No, StausFlag*TxFlag*RankFlag as Flag;
LOAD D.No,
  If( Count(DISTINCT If(Match(Staus,'H','S'), Staus))=2, 1,0) as StausFlag,
  IF( Only(If(Staus= 'H',Tx))=Only(If(Staus='S',Tx)), 1,0) as TxFlag,
  IF( Only(If(Staus= 'H',rank))=Only(If(Staus='S',rank)), 1,0) as RankFlag
Resident Sheet1$
GROUP BY D.No;