topic Re: aggr should not include month in QlikView

aggr should not include month

Mon, 14 Oct 2013 12:13:50 GMT

Hello,

I have this aggr expression:

SUM(
{ < Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}
aggr(
SUM(
{ < Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"}, "[DimTimeType].TimeTypeName" = {"ExternalBillableTime"} > }
"[FactQVTimeRegistered].TimeRegistered"
)
,"[DimOrganization].Name"
,DateKey
)
)

This expression DOES NOT include month - Which is correct:

However i have this expression:

/
SUM(
{ < Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}
aggr(
7.5 *
"[DimOrganization].FTE Factor" *
(
Count(
{<Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"}, "IsWeekend" = {'0'}, "[DimBankHolidays].BankHoliday" = {'0'}, DateKey = {'<=$(=vTodayDate)'} >}
distinct DateKey
)
-
sum(
{<Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}
"[Vacation2].Days"
)
)
,"[DimOrganization].Name"
,DateKey
)
)

And this Expression Includes month BUT IT SHOULD NOT - What is wrong with it??

Re: aggr should not include month

bbi_mba_76 — Mon, 14 Oct 2013 13:05:36 GMT

Hi,

is "[DimOrganization].FTE Factor" depending on Month field ?

Otherwise you could try to remove the count or sum to find where there is the error.

Re: aggr should not include month

Gysbert_Wassenaar — Mon, 14 Oct 2013 15:22:51 GMT

If "[DimOrganization].FTE Factor" is a field then you have an implicit aggregation that does not exclude selections in the Month field. Try replacing it with something like: only({ < Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}"[DimOrganization].FTE Factor")