set Analysis

[francofiorillo]

Hi

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]

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

[Anonymous · Accepted solution]

You can try using this:

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

Regards,

Gabriel

[jyothish8807]

Hi,

Try this

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

Regards

KC

[MK_QSL]

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

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