Hi Qlik Community,
I am not familiar with all Qlik features and I require help with the following:
I use Qlik in a Sales team. In order to score in a Sales activity, each individual needs to sale minimum 1 item per category, 3 category out of 4.
To visualize this, Items are replaces by letters, categories are lines. 4 lines = 4 categories, as follows:
1- A,B,C
2- D,E,F
3- G,H,I
4- J,K,L
Example: If John sales item A, D and G, he succeeds (3 items in 3 different categories).
If John sells item A, B and C, he does not succeed (3 items in the same category. Needs to be 3 different categories).
What kind of statement should I use?
