Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try using this:
=sum ({ $ <OrderDate = P(DeliveryDate) >} sales)
Regards,
Gabriel
=sum (If(OrderDate = DeliveryDate,sales))
You can try using this:
=sum ({ $ <OrderDate = P(DeliveryDate) >} sales)
Regards,
Gabriel
Hi,
Try this
sum ({ $ <OrderDate = {'DeliveryDate'} >} sales)
Regards
KC
The expression is for finding sales where DeliveryDate is same on OrderDate... you can use below
=SUM({<OrderDate = P(DeliveryDate)>}sales)