Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thank you Chrismarlow. It works. Apologies for late response.