Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Matrix showing combinations

Hi

I have a little puzzle.
I have a table with user and group connections as shown here

GroupUser
10A
10B
10C
11A
11C
12B
13A
13B

         

I need to produce a matrix showing the number of user that has connections to the different combinations groups as
shown here

    


 


 

 

10


 

 

11


 

 

12


 

 

13


 

 

10


 

 

3


 

 

2


 

 

1


 

 

2


 

 

11


 

 

2


 

 

2


 

 

0


 

 

1


 

 

12


 

 

1


 

 

0


 

 

1


 

 

1


 

 

13


 

 

2


 

 

1


 

 

1


 

 

2


 

    

I recognize that I might have to generate a table like this 

 

GroupGroup2User
1010A
1010B
1010C
1011A
1011C
1012B
1013A
1013B

(just for the first column)

On the basis of the first table, but how to do it?

1 Solution

Accepted Solutions

Re: Matrix showing combinations

How about the attached?

2 Replies

Re: Matrix showing combinations

How about the attached?

Not applicable

Re: Matrix showing combinations

Thanks it was exactly
what I were looking for, my problem was that I was building on the existing
table and there creating problems in the other graphs, but using this and
creating a new table made it work.  

Community Browser