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.
