Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

flag

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 ?

4 Replies
subbareddykm
Creator II
Creator II
Author

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

MarcoWedel

Please post example values and expected flag results.

Regards

Marco

subbareddykm
Creator II
Creator II
Author

Flag.JPG

swuehl
MVP
MVP

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;