topic Create Flag in QlikView

Create Flag

suzel404 — Sun, 05 Jun 2016 13:53:01 GMT

Hi all,

How can I identify with a flag in script all ID without TYPE_ID = 4 and ID WITH TYPE _ID = 4

Thanks for your help.

Regards,

Peter_Cammaert — Sun, 05 Jun 2016 14:03:59 GMT

Not too difficult, I think. Like this (there are multiple possible solutions)?

MapIDHasType4:

MAPPING

LOAD ID, 1 AS Flag

FROM FLAG_TYPE.xls (biff, embedded labels, table is Sheet1$)

WHERE (TYPE_ID = 4);

IDsNTypes:

LOAD ID, TYPE_ID, ApplyMap('MapIDHasType4', ID, 0) AS FlagHasType4

FROM FLAG_TYPE.xls (biff, embedded labels, table is Sheet1$);

Add whatever other calculations you need to the last straight LOAD.

Best,

Peter

suzel404 — Sun, 05 Jun 2016 14:14:43 GMT

Thank you Peter.