topic Re: Pivots Tables and Set Analysis in App Development

Pivots Tables and Set Analysis

Thu, 11 Aug 2016 14:22:04 GMT

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 — Thu, 11 Aug 2016 15:20:32 GMT

Do you mean displaying marks in Numbers not in Percentage ?

try this !!!

SOURCE:

LOAD [Student Name],

Physics,

Chemistry,

Maths,

English,

[Total Marks]

FROM

(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;

Thu, 11 Aug 2016 16:01:41 GMT

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