Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ssalian279
New Contributor

I have a set of records (excel file) with customer and subscription details. For every customer, based on the order date, I would like to see who made a different product purchase.

for eg:

Customerdateproduct
A12/10/2016ProductX
A04/10/2017ProductX
B11/07/2016ProductM
B10/06/2017ProductM
C05/10/2017ProductH
A01/01/2018ProductY

I would like to come to a conclusion that Customer A bought different products. ( or just a count of how many people went on to purchase different products) Further on, I would also like to know how many went on to buy product Y from product X.

In SQL, it would be something like this:

Partition by Customer, Order by date,

select customer with count(product)>1

My objective is to analyse customer journey and I would like to hear any suggestions or recommendations on the best way to do it.

Tags (1)
2 Replies
ssalian279
New Contributor

Re: I have a set of records (excel file) with customer and subscription details. For every customer, based on the order date, I would like to see who made a different product purchase.

I used a table chart and added relevant fields and sorted by customer and date. I was wondering if a calculated field in the table would help answer my question. Or if I'll need to explore scripting to solve this. (using for each function)...

OmarBenSalem
Esteemed Contributor

Re: I have a set of records (excel file) with customer and subscription details. For every customer, based on the order date, I would like to see who made a different product purchase.

for this of data:

Customerdateproduct
A12/10/2016ProductX
A04/10/2017ProductX
B11/07/2016ProductM
B10/06/2017ProductM
C05/10/2017ProductH
A01/01/2018ProductY

could u please show us what's the resulting table you're expecting to create?

Community Browser