Set Analysis to sum data that falls between dates.

Tue, 15 Nov 2011 13:40:20 GMT

The Problem:

I am trying to create an open order book and need to be able to sum all orders that follow this rule...

Order date <= Date & Posting date is > Date

I currently have this expression in place but it is not giving me the required output.

Sum({$< OrderDate={"<=$(Date)"}, PostingDate={">$(Date)"}>}NetVal)

I get the feeling that this will break when it hits the last date available but I am not sure how to cater for this...

any help would be appreciated.

Thanks

SunilChauhan — Tue, 15 Nov 2011 14:04:03 GMT

use this

Sum({$< OrderDate={"<=$(=Date)"}, PostingDate={">$(=Date)"}>}NetVal)

i think it will not break when you use field .and when you will use variable then it might break

topic Set Analysis to sum data that falls between dates. in QlikView