Odd result

jonathandienst — Fri, 13 Aug 2010 08:25:59 GMT

I have a puzzle (for those who like them [:D]).

I have a model for a call center system for which an expression on a straight table/combo chart is producing odd results. First off, the set expression:

Sum({<CallDate={">=$(=MonthStart(Max(Total CallDate))) <=$(=MonthEnd(Max(Total CallDate)))"}>} Attempts)

works correctly, but I am trying to understand why this supposedly similar SumIf expression gets the wrong result:

Sum(If(CallDate >= MonthStart(Max(Total CallDate)) AND CallDate <= MonthEnd(Max(Total CallDate)), Attempts)).

CallDate is a field on the CallRegister table, Attempts is a flag field (1 or 0) on an analysis table linked 1:1 by CallID to the CallRegister. If Attempt is missing or zero, the call register entry was a "phantom" and not to be included in the count. See the figure for a snip of the table structure.

On a chart dimensioned by day of the month, for 1 August, the set expression gives a result of 3 (this is correct), while the SumIf gets 24.

Any thoughts as to why this is happening?[8-|]

Jonathan

Odd result

Fri, 13 Aug 2010 12:08:50 GMT

Hi Jonathan,

I'm trying to replicate this problem, but my Set analysis expression is giving me the same results as the normal expression.

hmmm.

It would be interesting to see why it is causing a difference with yours.

topic Odd result in QlikView

Odd result

Odd result