topic Re: How to study the association among fields in QlikView

How to study the association among fields

Tue, 21 May 2013 00:13:28 GMT

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

Re: How to study the association among fields

sushil353 — Tue, 21 May 2013 02:49:55 GMT

Hi,

Using Pivot table you can achieve this

Please find the attached sample application.

is this what u are looking for?

HTH

Sushil

Re: How to study the association among fields

Tue, 21 May 2013 14:19:07 GMT

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?