Customers who didn't buy a product - Part 2 - Qlik Community

sogloqlik · ‎2018-05-29

Hello Experts.

Some time ago I Posted a Question about Customers who didn't buy a product.

I Managed to come with a solution of some kind but now I was asked to not only to be able to select multiple product but to show them in a pivot table with the product as a dimension, I can't seem to achieve it.

Any help would be appreciated.

Motty.

sunny_talwar · ‎2018-05-29

Would you be able to share a sample of what you have and elaborate based on the sample about what you are trying to get?

sogloqlik · ‎2018-05-31

Hi.

I've attached a sample App.

Lets say I need to count all the customers whom bought and didn't but product 1002 & 1003 in 2018/05 and to show them buy product.

There is a Pivot Table in the APP which is what I need to present.

Thx

sunny_talwar · ‎2018-05-31

There are only two rows for 2018/05 and none of the customer bought 1002 and 1003 together? In fact there is only just Andy... what do you expect to see from the pivot table?

sogloqlik · ‎2018-06-03

Hi.

I expect to see the Material chosen(1002, 1003 and only them), Customer and then one measure counting the customers who bought(Let say they will be markes as 1) and another counting the customers who didn't(will be marked by 0).

Let's Leave the time period aside, It can be a certain month or the entire period.

Motty