5 Replies Latest reply: Nov 6, 2017 2:43 AM by Lucke Hallbergson RSS

    Build pivot table problem

    Rachel Zhong

      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!