Discussion board where members can get started with Qlik Sense.
Load * inline
1 as Flag1,
IF(MATCH(UPPER(Type), 'A'), 1) as Flag2,
IF(MATCH(UPPER(Type), 'B', 'C'), 1) as Flag3
DROP TABLE Table;
Go to Solution.
load max(Flag3) as Flag3 , max(Flag1) as Flag1, max(Flag2) as Flag2 , ID group by ID;