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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.