Pivots Tables and Set Analysis

[#1]

I have a table as shown below:

Student Name	Physics	Chemistry	Maths	English	Total Marks
Ram	0.3	0.2	0.25	0.25	360
Raj	0.6	0.1	0.1	0.2	345
Krishna	0.3	0.2	0.15	0.35	339
King	0.2	0.15	0.15	0.5	330
Queen	0.25	0.15	0.25	0.35	345

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?

[Anonymous · Accepted solution]

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;

[#3]

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