Use Expression Total in another Expression

[#1]

Hi,

I have added a new Expression in a Pivot Table that sums other expressions. This new field is called Score and it exists only in one Pivot Chart.

I want to use the Expression Total for Score somewhere else. Is this possible?

Hopefully this makes sense as i wast sure the technical way to explain this.

Thanks

Stuart

[MK_QSL]

You can't use expression name of one table to another.. You need to use the full expression itself..

[Gysbert_Wassenaar · Accepted solution]

Qlikview is not a spreadsheet application, so referencing a cell in another table is not possible. You will have to create an expression that calculates that Total in the object where you want to use it again. Perhaps it's possible to use the same expression you use in your pivot table, but without looking at your document there's no way for me to be sure.

[Anonymous]

you can try to use a variable with the expression and insert the variable in the expression

as often as you need. I try to use this approach, so you only need to change the expression once

[#5]

Thanks - i was thinking of using a similar expression however I would need to change the Expression.

Right now I am using

sum(Email_Space)+sum(Email_CountDblAt)+sum(Email_DblPeriod)+sum(Email_PeriodFirst)+sum(Email_PeriodLast)+sum(Email_PeriodAt)+sum(Email_AtPeriod)+sum(Email_BadChars)

This gives a total of about 150. Hoever I just need the expression total which is 15. (ie 15 lines with a value of >0 for the above expression.