topic Product Mix Charts in QlikView

Product Mix Charts

manojkulkarni — Thu, 05 Mar 2015 12:09:21 GMT

Hi All,

I need to make analysis on top n products sold against each product. How we can achieve this ?

Expected result :

When ever user buy a product1, he is buying prod6,prod7, prod4 most of the times. same way for other products.

Roop — Thu, 05 Mar 2015 12:42:33 GMT

Hi Manoj,

a few questions for you:

Is there a difference between a user buying prod1 buying prod6, prod7 and prod4 most of the time and a user buying prod6 vs prod1, prod7 and prod4? In other words do you know the precedence of the products sold?
Have you got some test data?
What should this look like at an aggregated level as it is quite easy to see at an individual user level?

Many thanks

Rupert

robert_mika — Thu, 05 Mar 2015 12:44:52 GMT

So you need a rank of your Prod1,Prod2, column...

and the answer for Prod1 will be

1.Prod7

2.Prod4....