Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am a bit new to Qlik Sense and struggling to create the following:
I have a table with CUSTOMER_ID and ITEM_NAME and I want to know the number of customers that bought two specific articles out of the ITEM_NAME list, lets say "teddy" and "bunny". It is important that the count of customers that I get bought both those items
I could not find anything so far in the forum.
Thanks in advance
Hi try this
Count({<ITEM_NAME={'teddy'}>} CUSTOMER_ID) * Count({<ITEM_NAME={'bunny'}>} CUSTOMER_ID)
Hi!
Unfortunately this multiplied the number of people where one condition was true times the number of people where the other condition was true and did not give me the number of people where both conditions are true
May be this
COUNT(DISTINCT {<ITEM_NAME={"teddy","bunny"}>} CUSTOMER_ID)
Or
COUNT(DISTINCT {<ITEM_NAME={"teddy"}>} CUSTOMER_ID / {<ITEM_NAME={"bunny"}>} CUSTOMER_ID)