1 Reply Latest reply: Nov 30, 2017 11:52 PM by Nita Prasad RSS

    Qlik data vizualization for Pivot

    Nita Prasad

      !@@Hi Team,

      we have a below requirement

       

      RegionChannel17-Jul17-Jun
      SouthChannel1018
      WestChannel2125
      EastChannel3137
      NorthEastChannel4186
      NorthChannel5193
      Total6239

      Total is nothing but Sum of Jul-17 and Jun-17 aggregate.

       

      The requirement is to show the Total somewhat like below

       

      RegionChannel17-Jul18-Jun
      Total6239
      SouthChannel1018
      WestChannel2125
      EastChannel3137
      NorthEastChannel4186
      NorthChannel519

      3

      Please note, we tried using partialsum, that failed when there are null values or missing valus, whole data becomes null in that case. Could you please see if that is feasible.