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

# Pivots Tables and Set Analysis

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

Hi

Do you mean displaying marks in  Numbers not in  Percentage ?

try this !!!

SOURCE:

Physics,

Chemistry,

Maths,

English,

[Total Marks]

FROM

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

NoConcatenate

OUTPUT:

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

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])