Possiblilities for statistical relationships in Qlikview

[#1]

Hello all,

I have a question regarding the possiblities of statistical relationships in Qlikview.

Is it possible when you select in an overview a specific article that QV shows what other customers also bought when buying that article? ('what other customers also bought')

Example Customer data:

Customer	Article	Quantity
A	1	10kg
A	2	5kg
B	1	5kg
C	1	10kg
C	2	5 kg
C	3	2kg
D	1	2 kg
D	4	4 kg
D	3	2 kg

For example Customer B with article 1.

When I select Article 1 I would like to get an overview that when buying Article 1 .

most customer also bought article 2

- 2 customers also bought Article 3

- and 1 customer also bought 4 (less important since it was bought only once)

Preferable in a Top x overview

Is such thing possible in Qlikview? And which graph it the adviced one to use?

Regards, Bianca

[Anonymous]

So what is your requirement?

You want most prefered Article like which one is purchased most of the time, is it?

[#3]

I would like to make a graph or report  that gives an overview when I select article 1 the articles that other customers also bought when the bought Article 1

[Mahamed_Qlik]

Hi Bianca,

You might have know the Qlikview by defaultwork on ÄND' logic and here in your scenario you are tyring to apply ÓR'

logic. Well it is possible by using Alternate state feature provided by Qlik.

Here is the details : About Alternate state.

Hope it helps you.

Regards,

Mahamed

[#5]

Thanks Mahamed for your input.

It is not completely what I am looking for.

I want to select Article 1 and than see all Customers that purchased Article 1 and more important I would like to see which other Article's those customers purchased

For the example I see in my overview that Customer B purchased Article 1. So I select Article 1

And then in another overview I want to see :

Customer A purchased Article 1 and Article 2

Customer C purchased Article 1 and Article 2 and Article 3

Customer D purchased Article 1 and Article 3 and Article 4

Based on above overview I know that when a Customer Purchase Article 1 they might be interested  also  purchasing Article 2 and 3.

This information we can use for upselling purposes.

Hopefully this explains it a bit better.