topic mix analysis in QlikView

mix analysis

andyrebs — Wed, 10 Oct 2012 17:05:22 GMT

Dear All

I need help and I hope that you have the solution for my problem. I would like to have an expression that extrapolate, if I select a product or a family product, the other Families that cusomers buy with. I try to explain, if I have a db with these values in the column Family: meat, fish, vegetable, bread and I select fish, I would like to know which other types of Family the customers buy and how.

If you need more information, please let me know.

Thanks

Andrea

Re: mix analysis

thomas_skariah — Fri, 12 Oct 2012 02:41:41 GMT

Hi Andrea,

Can you explian in detail.

Regards,

Tom

Re: mix analysis

Anonymous — Fri, 12 Oct 2012 06:37:59 GMT

Sounds like Basket Analysis.

Set analysis with expressions such as this may help (taken from Advanced training manual page 75) ...

sum({$<Customer=

{'=sum({1<Product={'A'}>} LineSalesAmount) > 0'}

{'=sum({1<Product={'D'} LineSalesAmount>) > 0'}

LineSalesAmount)

I think it all has to be on the one line, but I split it up to aid understanding.

Jonathan

Re: mix analysis

andyrebs — Fri, 12 Oct 2012 07:30:35 GMT

Hi,

first of all , thank you both for help. Jonathan, I think you are right when you talk about Basket Analysis.

Meanwhile I asked another similar question on the community.

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

I think I have found the right expression but, certainly, I will try your suggestion.

Thanks