6 Replies Latest reply: Mar 25, 2016 4:06 AM by Peter Cammaert RSS

    Layout issue in qlikview pivot

    Santosh Roy

      Hi,

       

      It will be great help to me if somebody help me sort this issue.



      In qlikview pivot, one can adjust the expression layout based on dragging it at column level or row level,


      But in depends on type of data. But i need some help to adjust the layout.


      Background :


      i have two expression Business (fy 16-17) & New rate (month wise).


      Business is one value for whole year (irrespective of numbers of entries or new rate), while new rate has more the one entry.


      if i tried pivot in qlikview, i will get output as pic 1 & pic 2....


      while i would like to have output as pic 3





       

       

      Pic 1

       

      PIC1.jpg

       

      PIC2

      PIC2.jpg

       

      PIC 3

      PIC3.jpg