Build pivot table problem

[Anonymous]

Hi dear all, I am new for the Qlik sense cloud. I am going to use this to analysis my survey data.

Currently I have one table list below:

So I am going to build a sheet like this:

I would like to use 'Client', and 'surveydate' as the dimension, and max field is the max value of Q1-1t, Q2-2t,....... 'No of respondent' is the number of each filed record. Sadly I have no idea how show I start it, anyone give me some suggestions will be really appreciated. Thanks so much!

[devarasu07]

Hi,

Can you share your mock data in excel/text file format.

Uploading a Sample

[Lucke_Hallbergson]

Something like this? Also see attached example app.

[Anonymous]

Hi, Lucke, Thanks for your reply. Yes, this is something I would like to use. And the example you listed below, sadly I don't know how to open it. It looks like an Qlik sense file, I am still working on how to open it. But anyway, tks.

[Anonymous]

Hi Lucke,

I opened the example and have been tried to build this. I found it seems you create fields called 'question' and 'question.value', how did you create them? Thank you!

[Lucke_Hallbergson]

I used the unpivot function in Data Manager to take the Q* fields and place them into 2 fields,  question and question.value.

Unpivoting crosstab data in the data manager ‒ Qlik Sense

Unpivoting crosstab data in data manager ‒ Qlik Sense

Regards

Lucke