mix analysis

[andyrebs]

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

[thomas_skariah]

Hi Andrea,

Can you explian in detail.

Regards,

Tom

[Anonymous]

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

[andyrebs]

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