Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mariasdu
Contributor

How to edit a pivot table - add an expression as a new variable

Hi

I'm editing an existing QV application showing the results of different exams.

One table is made like the one below (showing the results from a given exam on different dates):

Another table is made like the one below (showing the grades given to the students on different dates):

Both tables is made as pivot tables in QV.

Now I want to add the information of Average grade from table 1 to the table below - either between "Not passed" and "Total" or to the right of "Total"

But when I go to properties- add an expression and insert the code for calculating the average, it is inserted in a strange way like the one seen below:

How can I add the information of average in a single columnNext to for example "total"??

Kind Regards Maria

1 Reply

Re: How to edit a pivot table - add an expression as a new variable

In the Pivot table, we can't add the expression like that. You need to do this in Dimension Level (Add Calculated Dimension ) using the Valuelist function (in this case, i think it is little bit difficult because of more Grade data)

Or you need to do this Script Level Or You have to create the Straight table, put the separate expression for each Grade.

Community Browser