Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andyrebs
Contributor III
Contributor III

Expression to know the mix product

Hello

I would have an expression in a chart, that can let me know what else custumers buy when they buy a specific product.

I attached for you perusal an excel file with three sheets.

  1. Sheet 1 : customer details
  2. Sheet 2: order details
  3. Sheet 3 : product details

Is it possible to select a Family and view what else, the custumers those buy the selected family , buy.

I hope you can help me.

Thanks

Andrea

13 Replies
swuehl
MVP
MVP

So why not just use

=count({<Company = p(), Family= >}[Order N°]) / count(total {<Company = p(), Family= >}[Order N°])

or

=count({<Company = p(), Family= >}[Order N°]) / count(total<Company> {<Company = p(), Family= >}[Order N°])

and format the number on numbers tab as percentage.

andyrebs
Contributor III
Contributor III
Author

2nd Expression works, first one, that I had tried before asking you, doesn't.

Thanks again.

I think this kind of analysis is very interesting, but maybe you know something more usefull.

We want to cut some products, but we don't know the effects that this razionalization should has on our sales.

It could be interesting even a pivot chart? with as dimension family and inside again the families those are bought with the first family. I know.. My reasoning is complex, but I hope I understand me, again!

swuehl
MVP
MVP

You can check these samples and see if they match your requirements:

http://community.qlik.com/message/162179#162179

http://community.qlik.com/message/225432#225432

andyrebs
Contributor III
Contributor III
Author

Thank you Stefan,

unfortunately I have the free version and I can not open the example files, nevertheless You was very very kind.

Best regards

Andrea