Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
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