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: 
Anonymous
Not applicable

3 Weeks Ago IN Set Analysis

I am trying to do a sum of a $$ field where the created date is three weeks (21 days) old

=(sum({<CreatedDate={">=Date(Today()-21)"}>}Upsell_ARR__c)) is not working

But when I hard code the date it works

=(sum({<CreatedDate={">=2/21/2018"}>}Upsell_ARR__c))

When I just do the set analysis Date(Today()-21) in a text box I get 2/21/2018, which is correct

What am I missing?

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({<CreatedDate={"$(='>=' & Date(Today()-21, 'M/D/YYYY'))"}>}Upsell_ARR__c)

View solution in original post

2 Replies
el_aprendiz111
Specialist
Specialist

Hi,

sum({<CreatedDate={'>$(=Date(Today()-21))'}>}Upsell_ARR__c)

sunny_talwar

Try this

Sum({<CreatedDate={"$(='>=' & Date(Today()-21, 'M/D/YYYY'))"}>}Upsell_ARR__c)