Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone! I was wondering if anyone could help me with this little problem I am having with Qlik Sense. I get how to make a regular table or Pivot Table but how do you make one with this type of format?!
So the Excel sheet has each question as its own column and then what they responded. How do you get these columns to be rows like this? I don't get it! Any help would be appreciated. Thanks!
Questions | % marked a 5 or above |
1 | % |
2 | % |
3 | % |
4 | % |
5 | % |
6 | % |
Something like this if each question identified by questionID and answer in field question1answer, question2answer, etc
Sum({$<questionID = {"=question1answer>5"}>} question1answer)/Sum( question1answer)
or better if question number field
Sum({$<questionID = {"=question1answer>5"},questionNum={1}>} question1answer)/Sum({$<questionNum={1}>} question1answer)
Hi dwforest...sorry I got caught up in the holidays and am replying extremely LATE!
The questions are number fields.
So you are saying I would be putting this as the expression?
I read something about crosstables...is this what I am supposed to be using?