Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarroura97
Partner - Contributor
Partner - Contributor

Matrix with same Dimensions on X and Y Axis

 

Hello, 

I am looking to create something like a matrix, comparing values across X and Y dimensions to calculate the number of customers by category. The cell result would be an % for the other cross names of the category and for the same name of category should be the number of customers. Any suggestions ?

 

Scenario: Among the 100 customers who consume category 1, 33% also consume category 2 , while 45% consume the category 3.

Scenario: Among the 50 customers who consume category 2, 64% also consume category 1 , while 61% consume the category 3.

Exemple :

  Category 1 Category 2 Category 3
Category 1 100 33% 45%
Category 2 64% 50 61%
Category 3 67% 64% 64

 

 

#Matrix 

0 Replies