Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table as shown below:
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?
Go to Solution.
Do you mean displaying marks in Numbers not in Percentage ?
try this !!!
LOAD [Student Name],
(html, codepage is 1252, embedded labels, table is @1);
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
DROP Table SOURCE;
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.