topic Sum of Rows vs. Expression Total in QlikView

Sum of Rows vs. Expression Total

jcampbell474 — Fri, 06 Apr 2018 17:57:27 GMT

I have a straight table where the row level numbers are correct, but the subtotal isn't. I found several threads around this and it looks to be an aggregation issue, but can't get anything to work.

Can anyone help me understand what I'm doing wrong?

((avg(aggr(sum(SalaryxMin),UserId,cReportGroup, FiscalYearMonth ))*

((sum(HandleTimeSecs/60)) +(sum(aggr(sum(total <UserId,FiscalYearMonth,cReportGroup,Location> {<cReportGroup=,CS_Dept=>} AvailSecs)/60*sum(WorkGrpSecs)/sum(total <UserId,FiscalYearMonth,Location> {<cReportGroup=,CS_Dept=>} WorkGrpSecs),UserId,cReportGroup,FiscalYearMonth,Location))))))

TIA,

Jason

Re: Sum of Rows vs. Expression Total

sunny_talwar — Fri, 06 Apr 2018 18:21:25 GMT

Basically to sum the rows, you need to have an Sum(Aggr( YourExpression, YourDimension/s))

Sum of rows in pivot tables‌

Sum(Aggr(

((avg(aggr(sum(SalaryxMin),UserId,cReportGroup, FiscalYearMonth ))*

,YourDimensions))

Re: Sum of Rows vs. Expression Total

jcampbell474 — Fri, 06 Apr 2018 19:43:18 GMT

Ah, okay. Perfect!

Thank you again, Sunny. You make it look so easy!