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: 
Francisco_SP
Contributor II
Contributor II

Matrix calculation

Hi,

From the below table, I would like to calculate the intersection between two columns in a percentage. The calculation for this is in red.

Annotation 2020-01-03 124709.png

SUM( {< NoOfCompareTheMarket={">=1"}, NoOfConfused={">=1"} >} NoOfConfused)
/
SUM( {< NoOfCompareTheMarket={">=1"} >} NoOfCompareTheMarket)

The outcome would be something like below.

I would like to know if there's any way that this calculation is done automatically for every combinantion. 

Thanks in advance

Annotation 2020-01-03 130223.png

Labels (2)
2 Replies
Sue_Macaluso
Community Manager
Community Manager

@Francisco_SP Are you using Qlik Sense or QlikView?  I would like to move this into the correct product forum. 

Sue Macaluso
Francisco_SP
Contributor II
Contributor II
Author

Qlik Sense