topic Re: Group two columns to discover relationship in QlikView

Group two columns to discover relationship

paulosrl — Mon, 06 Mar 2017 19:52:55 GMT

Dear all,

I have one table, with some columns, but I have two columns with names, I need discover relationship between these columns. I've tried but I cant display the data in one single table in an appropriate layout ou graph.

My main table is something like that:

NAME1	NAME2
A	N1
B	N2
C	N3
D	N3
E	N1
F	N4
G	N2
H	A
I	A
J	N5
K	N1
L	B
M	A
B	C
A	E

I need a result like that: (the display order must be based on number of relationship + name)

Result
NAME2	RELATIONSHIP	Number of relations
A	H	3
	I
	M
N1	A	3
	E
	K
N2	B	2
N2	G	2
N3	C	2
N3	D	2
B	L	1
C	B	1
E	A	1
N4	F	1
N5	J	1

Thanks!

Re: Group two columns to discover relationship

maxgro — Mon, 06 Mar 2017 20:06:06 GMT

this is a pivot with 2 dimensions NAME2 NAME1

and as expression count(TOTAL <NAME2> NAME1)

text color for expression is if(rowno()<>1, white())

sort is

Re: Group two columns to discover relationship

paulosrl — Tue, 07 Mar 2017 00:24:10 GMT

Nice job ! Thanks for help! Works fine ! 🙂