Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulosrl
Contributor III
Contributor III

Group two columns to discover relationship

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:

 

NAME1NAME2
AN1
BN2
CN3
DN3
EN1
FN4
GN2
HA
IA
JN5
KN1
LB
MA
BC
AE

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

   

Result
NAME2RELATIONSHIPNumber of relations
AH3
I
M
N1A3
E
K
N2B2
G
N3C2
D
BL1
CB1
EA1
N4F1
N5J1

Thanks!

2 Replies
maxgro
MVP
MVP

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())

1.png

sort is

2.png

paulosrl
Contributor III
Contributor III
Author

Nice job ! Thanks for help! Works fine ! 🙂