topic Use Expression Total in another Expression in QlikView

Use Expression Total in another Expression

Tue, 02 Sep 2014 10:31:43 GMT

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

Re: Use Expression Total in another Expression

MK_QSL — Tue, 02 Sep 2014 10:33:46 GMT

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

Re: Use Expression Total in another Expression

Gysbert_Wassenaar — Tue, 02 Sep 2014 10:35:04 GMT

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.

Re: Use Expression Total in another Expression

Anonymous — Tue, 02 Sep 2014 10:37:52 GMT

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

Re: Use Expression Total in another Expression

Tue, 02 Sep 2014 10:44:32 GMT

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.