Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

francofiorillo
New Contributor III

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
gabriel_kirst
Contributor III

Re: set Analysis

You can try using this:

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

Regards,

Gabriel

4 Replies
anbu1984
Honored Contributor III

Re: set Analysis

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

gabriel_kirst
Contributor III

Re: set Analysis

You can try using this:

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

Regards,

Gabriel

jyothish8807
Honored Contributor II

Re: set Analysis

Hi,

Try this

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


Regards

KC

Best Regards,
KC

Re: set Analysis

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

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

Community Browser