Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

xiyuzw1113
New Contributor III

Build pivot table problem

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:

Capture 1.PNG

So I am going to build a sheet like this:

Capture2.PNG

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!

Tags (1)
5 Replies
devarasu07
Honored Contributor II

Re: Build pivot table problem

Hi,

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

Uploading a Sample

Employee
Employee

Re: Build pivot table problem

Something like this? Also see attached example app.

screenshot.jpg

xiyuzw1113
New Contributor III

Re: Build pivot table problem

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.

xiyuzw1113
New Contributor III

Re: Build pivot table problem

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!

Employee
Employee

Re: Build pivot table problem

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

Community Browser