topic Use expression total in a new calculation in QlikView

Use expression total in a new calculation

Wed, 19 Aug 2015 11:29:17 GMT

Guys hopefully someone is able to help me with the following:

I have a pivot table with a dimension Categories and an Expression with Hours.

I checked the Expression total and this works. What I need is a new expression to calculate the % percentage hours from the expression total. Is there a way to use the Expression total in a new expression?

Re: Use expression total in a new calculation

sinanozdemir — Wed, 19 Aug 2015 13:04:35 GMT

Hi Bart,

I believe you can achieve that by using Total or All in your aggregation functions. Please see below:

To get the overall expression total, I used Sum(All Amount) and to get the overall expression total by Sites, I used Sum(Total<Site> Amount) expression.

Hope this helps.