partial sums issue

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I'm facing issue with partial sums, problem was have used Aggr calculated expression.

Please any one can help me.

Thanks in Advance

Re: partial sums issue

sunny_talwar — Wed, 06 Jun 2018 14:31:03 GMT

It seems that the attached dashboard has section access. Can you remove it and repost it

Re: partial sums issue

paulwalker — Thu, 07 Jun 2018 11:33:44 GMT

Please can you check now

Re: partial sums issue

sunny_talwar — Thu, 07 Jun 2018 11:48:01 GMT

I am able to open up, now can you tell us what exactly is the issue you are facing?

Re: partial sums issue

bc-thebruuu — Thu, 07 Jun 2018 12:26:03 GMT

Hello

This should do the trick:

sum(Aggr(IF(Rep_Dept='Con Ops',

(SUM(AGGR(SUM(TOTAL <Month, Rep_Dept> {<Week=>} ConOpsTarget), Week, Month, Rep_Dept))

NetWorkDays(MonthStart(MIN(Common_Date)), MonthEnd(Max(Common_Date)), Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'), Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')))

NetWorkDays(MIN(Common_Date), MAX(Common_Date), Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

(SUM([Charge Rate] * [Weekly Time Cost Hours]) / 5) *

NetWorkDays(SUM(DISTINCT Aggr(NODISTINCT MIN({<[Staff Name]=, Rep_Dept=>}Common_Date), Week)), SUM(DISTINCT Aggr(NODISTINCT MAX({<[Staff Name]=, Rep_Dept=>}Common_Date), Week)),

Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

,Month, Rep_Dept,Week,

//Common_Date,[Charge Rate],

//[Weekly Time Cost Hours],

[Staff Name]

)

Re: partial sums issue

paulwalker — Thu, 07 Jun 2018 12:59:36 GMT

Thank you

topic Re: partial sums issue in QlikView

partial sums issue

Re: partial sums issue

Re: partial sums issue

Re: partial sums issue

Re: partial sums issue

Re: partial sums issue