IF notation with { and <

Wed, 15 Feb 2012 15:47:33 GMT

Hi!

Can someone explain me the following term in "if" language?

sum({1<OrderDate={">=$(=addmonths(monthend(max(OrderDate),)+1,-24)) <=$(=addmonths(max(OrderDate),-12))"}>}Sales)

It is not the same as: sum(if(OrderDate>=addmonths(monthend(max(OrderDate))+1,-12) OR OrderDate<=max(OrderDate),Sales))

And what is the meaning of the initial "1"?

Cheers,

Jonas

stephencredmond — Wed, 15 Feb 2012 16:11:46 GMT

Hi,

Not "OR", this is an "AND".

I read it as if Orderdate is in the Last Year To Date, then sum the sales.

The "1" tells the expression to use the "1" set, ignoring all other selections in the document.

Regards,

Stephen

topic IF notation with { and < in QlikView