4 Replies Latest reply: Sep 12, 2016 12:21 PM by Sunny Talwar RSS

    Multiple Fields with same values in Pivot Table

    Ant�nio Vilares

      Hi,

       

      Imagine that I have the following table that shows the name of some students as column name and his grades on a test as values:

       

      JohnPeterCarrizoStewart
      ABAC
      BCCD
      AAAB
      CCAC


      Students:
      LOAD Names
      FROM file;

       

       

       

      I only have four grandes and I want to obtain the count of grades of each student like this:

       

      ABCD
      John2110
      Peter1110
      Carrizo3010
      Stewart0111

       

       

      How can I do this in Qlikview?

       

      Many thanks!