topic Regarding doing sum using aggr function in QlikView

Regarding doing sum using aggr function

qliksus — Fri, 16 Oct 2009 18:47:09 GMT

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?????

Regarding doing sum using aggr function

Fri, 16 Oct 2009 19:21:26 GMT

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.

Regarding doing sum using aggr function

qliksus — Sat, 17 Oct 2009 11:46:44 GMT

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))