Create a correlation matrix from single dimension

ernstblaauw — Wed, 06 Dec 2023 11:00:45 GMT

I have a data structure that looks like this:

LOAD * Inline [ Question, RespondentID, Answer I like swimming,1,1 I like running,1,3 I like Qlik,1,10 I like swimming,2,2 I like running,2,10 I like Qlik,2,10 I like swimming,3,3 I like running,3,-1 I like Qlik,3,9];

So, I have three dimensions Question, RespondentID and Answer. Now, I would like to create a correlation matrix between the three different questions and how the answers correlate from the respondents within Qlik Sense.

This means I have the three different questions at the top, three different questions left and then in the data fields, I see if the answers given are correlated when looking at the answer per respondent.

I cannot get this visual to work. Has anyone an idea how to create such a correlation matrix?

Update:

To get the correlation between two specified questions, I can use the following measure:

correl( aggr( Avg({<Question={'I like swimming'}>} Answer), RespondentID ), aggr( Avg({<Question={'I like running'}>} Answer), RespondentID ) )

However, I am not succeeding in altering this measure so it creates a correlation matrix for multiple questions at once.

topic Create a correlation matrix from single dimension in App Development

Create a correlation matrix from single dimension