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

Anonymous — Tue, 04 Aug 2015 13:13:53 GMT

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

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

settu_periasamy — Fri, 07 Aug 2015 17:48:06 GMT

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.

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

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

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