Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sogloqlik
Creator
Creator

Customers who didn't buy a product - Part 2

Hello Experts.

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

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.

4 Replies
sunny_talwar

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
Creator
Creator
Author

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

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
Creator
Creator
Author

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