Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Calculate Post Date Order Values?

Hi QV Team,

I need help on my Expression, How to sum-up Post Dated Order Values?

I've attached my excel sheet. Pls give me the expression to achieve this.

10 Replies
Not applicable
Author

Hi Murali,

You can also try using the Set Analysis Syntax :

=Sum({$<[First Delv Date]={'>$(=(Today()))'}>} [Open Order])

Regards,

Kalyan