Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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?

1 Solution

Accepted Solutions
galax_allu
Valued Contributor

Re: Pivots Tables and Set Analysis

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;

2 Replies
galax_allu
Valued Contributor

Re: Pivots Tables and Set Analysis

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;

Not applicable

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