Area for people to learn more about current Qlik related job postings.
Hi Need to create output column in script please check below
Go to Solution.
DATA:LOADID,UPPER(Catogery) as CatogeryFROM [lib://QlikTest/Book1.xlsx](ooxml, embedded labels, table is Sheet1);
LoadID,COUNT(DISTINCT Catogery) as outputResident DATAGROUP by ID;
Can you please provide what is the logic behind the output Column.
How do you decide is it is 0, 1 or 2?