2 Replies Latest reply: Aug 12, 2017 3:39 PM by Saima SM RSS

    Pivot Table in QlikSense

    Saima SM

      Dear All,

       

      I have data sample as give below (full sample file attached)

       

      Sample Data

         

      1monthStatus3monthStatus6monthStatus12monthStatus
      NoChange
      NoChange NoChange
      NoChange
      NoChange NoChange
      NoChangeQuitQuit
      NoChangeNoChangeReduced

       

       

      can anybody help in producing pivot table in Qlik Sense like give below. ( I want to use only chart function no any other reformatting of data table in load script since it will change data model. Thanks

       

      Desired Table in QlikSense

       

      .

        • Re: Pivot Table in QlikSense
          Petter Skjolden

          I have a solution for you built on a straight table by only employing chart functions. Since you don't have a dimension field in the data model when importing the raw data unmodified into Qlik Sense I used the ValueList(...) function to create a synthetic dimension. Then I will have to refer to the exactly the same ValueList in the expressions for the various measures for each time category. Have a look at the attached app.

           

          2017-08-12 14_42_54-_qc 271025 - pivot - My new sheet _ Data manager - Qlik Sense.png

          2017-08-12 14_43_48-_qc 271025 - pivot - My new sheet _ Data manager - Qlik Sense.png

           

           

          2017-08-12 14_44_31-_qc 271025 - pivot - My new sheet _ Data manager - Qlik Sense.png