Discussion board where members can get started with Qlik Sense.
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.
Your table like below:
Crosstable (TIER, YESNO, 1)
(ooxml, embedded labels, table is Sheet1);
And Your Measure Like Below:
maybe just do this :
load ID,'TIER1' as TIERS resident 'your table' where TIER-1 = 'YES';
load ID,'TIER2' as TIERS resident 'your table' where TIER-2 = 'YES';
load ID,'TIER3' as TIERS resident 'your table' where TIER-3 = 'YES';