4 Replies Latest reply: Jan 23, 2014 8:12 AM by Siddharth Lotlikar RSS

    Issue with formatting pivot table in mentioned format

    Siddharth Lotlikar

      Hi all,

      i am new in qlikview hence require a help in formatting issue

      We have a simple table like

      Fig 1:

      ClassStandardFirst NameLast NameNotesAttendance
      1ARohitSharma 20%
      1BKishorK 80%
      1CAmitM 30%
      2ARadhaK 60%
      2BDilpR 20%
      2CSidL 30%
      3AAbhiP 60%
      3BSomaSharma 20%
      3CKapilP 30%

       

      Required output should be:

      Fig 2:

      1
      ARohitSharma 20%
      BKishorK 80%
      CAmitM 30%
      2
      ARadhaK 60%
      BDilpR 20%
      CSidL 30%
      3
      AAbhiP 60%
      BSomaSharma 20%
      CKapilP 30%

       

      Is there any way to present class in such format..if i tried to group class it displays group wise data in first column like

      Fig 3:

      ClassStandardFirst NameLast NameNotesAttendance
      1ARohitSharma 20%
      BKishorK 80%
      CAmitM 30%
      2ARadhaK 60%
      BDilpR 20%
      CSidL 30%
      3AAbhiP 60%
      BSomaSharma 20%
      CKapilP 30%

       

      Fig 2 is the requirement.. Can you guys help me on this..

       

      Thanks in advance !

      Sid