Thanks you for your answer Gysbert!
Where do I put this code in Qlik Sense Desktop? Do I put it in the Data Import?
Do I need to change anything in the CSV-file?
I guess I need to write change/write something within the brackets here CrossTable(Question, Answer, 9)?
I guess the following might be useful to know to get this right. In the attached file (Import QS Colors.png) I have marked the questions and its components.
The green and blue marked text is the main question. “What do you shop online and how much do you spend on this per month in average during a year (regardless if its online or not)?”
The red marked text shows the products.
After the products you can see the two different kind of answers the person have given me, in Yellow, “amount spent per month” and in pink “Buys this online (Yes/No)”.
So this is the first question.
The second question is marked with brown color further down, “What would make you spend more money on these things online?”. I have marked all the alternatives of answers with the cyan color. The last answer means “Other (please specify)” and is an open answer where the person can write whatever he/she wants. The person who answers this question can choose as many alternative of answer as he/she wants. It can be non, it can be 1,2,3,4 etc. in any combination.
Thank you for your help and input.
Sorry for all the questions, I am new here and trying to learn. :-)
Import QS Colors.png 581.2 K