Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Partner - Master

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
Partner - Master

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.