Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a client list and 3 "Yes/No" Fields indicating whether or not a client has any of three products. For this example, lets say the products are Apples, Oranges, and Grapes. I would like to create a new field (Fruit Customer) indicating only the clients who have at least 1 of the products. I know in Excel this is achievable via If/Or expression, however I cant seem to figure out a Qlik approach.
Any help would be appreciated.
Thanks,
TJ
You can create flag to find clients which are Yes for only one product:
Table:
LOAD *,
If(SubStringCount(Apples&'|'&Oranges&'|'&Grapes, 'Yes') = 1, 1, 0) as Flag;
LOAD * Inline [
Client, Apples, Oranges, Grapes
A, Yes, Yes, No
B, Yes, No, No
C, No, Yes, Yes
D, No, Yes, No
];
Now use this flag in the set analysis or if statement to anywhere you would want to get only those clients where they have Yes for only one place