Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
francofiorillo
Partner - Creator
Partner - Creator

set Analysis

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

You can try using this:

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

Regards,

Gabriel

View solution in original post

4 Replies
anbu1984
Master III
Master III

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

Anonymous
Not applicable

You can try using this:

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

Regards,

Gabriel

jyothish8807
Master II
Master II

Hi,

Try this

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


Regards

KC

Best Regards,
KC
MK_QSL
MVP
MVP

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

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