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: 
dmarxer0414
Contributor
Contributor

Need correct syntax for date modifier

I'm trying to create an expression that says - if the field [Projected Close Date] is 370 days or more in the future, sum the combined_amount. Here is what I've written, but it isn't correct. What am I doing wrong?

 

Sum({<Date#([Projected Close Date])>={Date#(Today())+370}>}Combined_Amount)

Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Hi @dmarxer0414 

How about like this?

Sum({$<Date#( [Projected Close Date])= {">=$(=Date#(Today()+370)))"}>} Combined_Amount)

View solution in original post

2 Replies
BrunPierre
Partner - Master II
Partner - Master II

Hi @dmarxer0414 

How about like this?

Sum({$<Date#( [Projected Close Date])= {">=$(=Date#(Today()+370)))"}>} Combined_Amount)

dmarxer0414
Contributor
Contributor
Author

Thank you!! This worked (I needed the syntax inside the second brackets.