topic Re: Pivot Table Sum Aggregation based on Aggr Expressions in QlikView

Pivot Table Sum Aggregation based on Aggr Expressions

billuran — Mon, 13 Jun 2016 13:42:29 GMT

Hello All,

I have a pivot table with an expression that compares a Region's department's actual performance to a target and then from there creates a value of opportunity. Here is the expression.

(((Target-(sum({<[Exclude Hours]={'NO'},[Pay Type]={'Productive'}>} Hours)/Aggr(sum([Service Units]*Weight),Charged_BU,Charged_deptid)))*Aggr(sum([Service Units]*Weight),Charged_BU,Charged_deptid)/ppcount)*26/2080)))

Basically I cannot get this expression to total to the parent row of the pivot table. IE total each department's value to the appropriate region. It just shows -

Please let me know what other information i can provide.

Re: Pivot Table Sum Aggregation based on Aggr Expressions

sunny_talwar — Mon, 13 Jun 2016 14:03:31 GMT

Would you be able to share some screenshots to show where exactly are you having the issue and if possible share your qvw?

Re: Pivot Table Sum Aggregation based on Aggr Expressions

billuran — Mon, 13 Jun 2016 14:20:26 GMT

Sunny T, The FTE Variance is what I am after.

Re: Pivot Table Sum Aggregation based on Aggr Expressions

sunny_talwar — Mon, 13 Jun 2016 19:17:14 GMT

Do you want this to be the sum of rows? For 110, do you want to see -0.1+0.9-0.4 = 0.4?

May be try like this:

Sum(Aggr(

Bus...DimensionHere, Department))

Unable to see the full name for Bus...Dimension, but replace that with the actual field name from your QlikView application

Re: Pivot Table Sum Aggregation based on Aggr Expressions

billuran — Mon, 13 Jun 2016 19:24:53 GMT

Worked!, Cheers!