Regarding doing sum using aggr function

[qliksus]

hi,

Just open the jpeg file . You wil see left side there is a straight table where total sals day for year 2009 and month 9 is 1203. But when samething i want in text object it gives me 1201.

In the straight table i have witten the expression like

count(distinct if(%_RouteNumber<>'MISC01' or %_RouteNumber<>'MISC02' or %_RouteNumber='MISC03' or %_RouteNumber<>'MISC04' or %_RouteNumber<>'MISC05' or %_RouteNumber<>'MISC06'

Where In the text object i have written

sum(aggr(count(distinct if(%_RouteNumber<>'MISC01' or %_RouteNumber<>'MISC02' or %_RouteNumber='MISC03' or %_RouteNumber<>'MISC04' or %_RouteNumber<>'MISC05' or %_RouteNumber<>'MISC06'

But it is giving wrong answer. So can anyone help me how to get the total value in text object?????

[#2]

Hi,

Unfortunatly the code is cut, but I wanna ask you, what dimensions have place you at the aggr function? Month and TSEName? Have you tried whith set analysis?

Best regards.

[qliksus · Accepted solution]

Hi,

Sorry for the cutting code. Now i am putting full code,

sum(aggr(count(distinct if(%_RouteNumber<>'MISC01' or %_RouteNumber<>'MISC02' or %_RouteNumber='MISC03' or %_RouteNumber<>'MISC04' or %_RouteNumber<>'MISC05' or %_RouteNumber<>'MISC06',CallDate)%_RouteNumber, Call Date ,Month))