Information clustering & if commands

[#1]

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?

[awhitfield · Accepted solution]

Hi Hannes,

check out the simple example attached

HTH Andy