Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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;
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])