This content has been marked as final. Show 2 replies
I have been struggling with this for quite some time now and now I turn to you all.
I have a table which has IDs and TIER access (as shown below):
ID TIER-1 TIER-2 TIER-3
AA YES NO NO
BB YES NO YES
CC NO NO YES
Using the following script in the script editor I am trying to pull the Tier names for each ID that has 'YES' under the Tier columns:
WHERE Bought = 'Yes';
'TIER-3') AS Item,
Pick(IterNo(),[TIER-1],[TIER-2],[TIER-3]) AS Bought
FROM [lib://Qlik Sense/Test_v1.xlsx]
(ooxml, embedded labels, table is [ALL DATA])
Right now, if I filter out the ID "BB" in the output table, the output that I'm getting is;
which is incorrect....
My desired output is:
It should only show those Tier names for which Id: BB has "Yes".
I hope I could explain my problem.