How to study the association among fields

[#1]

Hey Helpers,

I am new to Qlikview. I have a question about a study for association among products. The data like this:

Customer_ID	Products_No
1	A
1	C
1	F
3	C
3	F
5	A
5	F

I want to reach a useful result like " People like to buy A and F at the same time. People like C is most likely to buy F. But people like F is equal likely to buy C and F."

My idea is transpose it to a wide table, like this:

Customer_ID	A	C	F
1	1	1	1
3		1	1
5	1		1

And then find the meaning from a logic like {"if A is not null", sum(F)>sum(C)" then People like to buy A and F at the same time.}

My question is

1. Do I have to transpose to solve my problem? Any better way?

2. How to transpose it?

3. How to apply my logic into QV?

Any help will be much appreciated,

Andy

[sushil353]

Hi,

Using Pivot table you can achieve this

Please find the attached sample application.

is this what u are looking for?

HTH

Sushil

[#3 · Accepted solution]

Good point, Sushil. Thanks. But how to apply my logic to the pivot table? It is not the column total, but a grouped column total. Right?