topic Re: Create a Flag in Script based on Condition in QlikView

Create a Flag in Script based on Condition

qlikwiz123 — Sat, 16 Nov 2024 01:56:31 GMT

I have data in the following way

ID CatID Status Flag (Expected Field)

1 1A Pending Complete/Pending

1 1B Complete Complete/Pending

2 2A Complete Complete

3 3A Pending Pending

3 3B Pending Pending

3 3C Pending Pending

4 4A Complete Complete

5 5A Pending Complete/Pending

5 5B Complete Complete/Pending

I need to create a new field called 'Flag' that says 'Complete/Pending' for the IDs that has both 'Pending' and 'Complete' in Status. If the ID has only one value in the Status field, then show the same Status value in the 'Flag'

How do I do this in the script?

Re: Create a Flag in Script based on Condition

Marcos_rv — Thu, 14 Nov 2019 20:16:16 GMT

Try this :

TABLE1:

LOAD ID,

CatID,

Status

from XXXXX.QVD;

LEFT JOIN (TABLE1)

load ID,

Concat(distinct Status ,'-' ) as Flag

resident TABLE1;

Saludos!!!

Re: Create a Flag in Script based on Condition

qlikwiz123 — Thu, 14 Nov 2019 21:12:49 GMT

Says Invalid Expression

Re: Create a Flag in Script based on Condition

qlikwiz123 — Thu, 14 Nov 2019 21:47:08 GMT

Needed to Group By. Will try. Thanks

Re: Create a Flag in Script based on Condition

Anil_Babu_Samineni — Fri, 15 Nov 2019 04:47:38 GMT

PFA

Re: Create a Flag in Script based on Condition

Marcos_rv — Fri, 15 Nov 2019 14:03:39 GMT

yep,

group by ID;

Very close !! jajaja