2 Replies Latest reply: Apr 18, 2016 4:47 AM by Christoph Schlunegger RSS

    Qlik Sense Pivot with percentages

    Christoph Schlunegger

      Hi all

       

      I have the following table with the rawdata:

               

      NRProjectTaskKSTKOAIDDescriptionStatusAssigneeRisk LevelDeadline
      1API Design 2ClosedJohnMedium18.09.2016
      2API Development 2BehindMarthaLow31.08.2016
      3API Testing 1Work in ProgressJill High14.07.2016

       

      and I need to produce the following pivot:
          

      Task Status/Priority HighMediumLowTotal% of Total
      Closed 010125%
      Work in Progress 110250%
      Behind 001125%
      Not Started 00000%
      Total 1214100%
      25%50%25%100%6.25

       

      Any Ideas how to achieve a pivot with percentages?

       

      Thanx and best regards