Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

setanalysis due date analysis

Hello,

I have a setanalysis problem, I want to calculate the sum of the amounts that are not due (DueDate < today). Using this wonderfull community I have found some formula's but none of them seem to work for me.

What is wrong with this one? : Sum({$<DATE(DueDate)= {"<$(=Today()"}>}Amount)

Many thanks for your help

1 Reply
adamwilson
Partner - Creator
Partner - Creator

Hi,

You cannot use functions on the fieldname within your set modifer only on the actual selection, define the data type in your load script i.e. Date(DueDate) as DueDate

You were also missing a closing parentheses.

The below should result in a sum of Amount where DueDate < Today

Sum({$<DueDate={"<$(=Today())"}>}Amount)

Adam