topic set Analysis in QlikView

set Analysis

francofiorillo — Fri, 10 Oct 2014 16:35:04 GMT

in a QlikView document, I found the following expression :

sum ({ $ <OrderDate = DeliveryDate >} sales)

i think there is a syntax error because the expression does not work.

Can you help me find the correct expression?

thanks

anbu1984 — Fri, 10 Oct 2014 16:39:06 GMT

=sum (If(OrderDate = DeliveryDate,sales))

Anonymous — Fri, 10 Oct 2014 16:39:40 GMT

You can try using this:

=sum ({ $ <OrderDate = P(DeliveryDate) >} sales)

Regards,

Gabriel

jyothish8807 — Fri, 10 Oct 2014 16:51:41 GMT

Hi,

Try this

sum ({ $ <OrderDate = {'DeliveryDate'} >} sales)

Regards

MK_QSL — Fri, 10 Oct 2014 16:57:42 GMT

The expression is for finding sales where DeliveryDate is same on OrderDate... you can use below

=SUM({<OrderDate = P(DeliveryDate)>}sales)