2 Replies Latest reply: Aug 11, 2016 12:01 PM by Ram Marthi RSS

    Pivots Tables and Set Analysis

    Ram Marthi

      I have a table as shown below:

       

      Student NamePhysicsChemistryMathsEnglishTotal Marks
      Ram0.30.20.250.25360
      Raj0.60.10.10.2345
      Krishna0.30.20.150.35339
      King0.20.15

      0.15

      0.5330
      Queen0.250.150.250.35345

       

      Suppose the data is a percent on a row basis totaling to 1 whose value is Total Marks.

      How can I get the exact values(Marks of each student) of each subject marks in a table in Qlik Sense?

      Should I use a Pivot Table or a Normal Table.

       

      Is there any scope to use Set Analysis with pivot table?

        • Re: Pivots Tables and Set Analysis
          Alluraiah Allu

          Hi

           

          Do you mean displaying marks in  Numbers not in  Percentage ?

           

           

           

          try this !!!

           

           

           

           

           

           

          SOURCE:

          LOAD [Student Name],

               Physics,

               Chemistry,

               Maths,

               English,

               [Total Marks]

          FROM

          [https://community.qlik.com/thread/228821]

          (html, codepage is 1252, embedded labels, table is @1);

           

           

          NoConcatenate

          OUTPUT:

          LOAD  [Total Marks],

          num(Physics)*num([Total Marks]) as Physics_marks,

          num(Chemistry)*num([Total Marks]) as Physics_Chemistry,

          num(Maths)*num([Total Marks]) as Physics_Maths,

          num(English)*num([Total Marks]) as Physics_English

          Resident SOURCE;

          DROP Table SOURCE;

          • Re: Pivots Tables and Set Analysis
            Ram Marthi

            Thanks Allu.

             

            I have first converted the table into a straight table by cross table and defined %marks as data and subjects as subject names.

             

            Now I tried this expression in defining the values in a pivot table.

            =sum([Total Marks])*sum({$}[%marks])