topic 3 Weeks Ago IN Set Analysis in QlikView

3 Weeks Ago IN Set Analysis

Anonymous — Mon, 05 Mar 2018 19:20:03 GMT

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?

el_aprendiz111 — Mon, 05 Mar 2018 20:16:18 GMT

Hi,

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

sunny_talwar — Mon, 05 Mar 2018 20:34:02 GMT

Try this

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