Correlation Co-efficient between different KPIs

[SivaChagaleti]

Hi All,

Can someone please help me with below problem I am struggling to solve?

We are planning to build a graph for Correlation Co-efficient (Pearson) between different KPIs we have on our Qlik Sense app.

For eg, you have 4 KPIs namely, KPI1, KPI2,KPI3 and KPI4.

I found that Qlik offers a function called Correl to find the correlation. Looks like Correl accepts only field names as attributes, I mean it doesn't support any expressions using SUM as attributes. It throws me an error saying 'nested aggregation not allowed'. 

For each of the KPI, I have an expression based on SUM, so I cannot use them inside Correl function.

Is there anyway to calculate the correlation coefficient in such scenarios? I need to find the coefficient for all possible combination of KPIs. 

Also, my second question is, what visual/chart suits best to plot correlation coefficient? do I have to import an extension? if yes, please provide the details.

Thank you in advance.

[chrismarlow · Accepted solution]

Hi,

So you can wrap AGGR round a SUM (or other aggregation) to allow it to appear inside CORREL (see toy application below).

I am not sure if/how this helps though as I don't really understand what calculating your correlations between all 4 KPI and plotting together means (beyond the obvious 8 text boxes with numbers in)

Cheers,

Chris.

[SivaChagaleti]

Thank you Chrismarlow.  It works. Apologies for late response.