Qlik Sense measure expression between two dates

[AnnieV]

Hi,

I have an app where I'm trying to display the sum of sales over the past 3 months
there is 1 table with sales & dates, and 1 table with date values (+ first day of month 3 months ago +last day of last month)
I use the following expression:

"    Sum({<Date={">=3MonthsAgo <=LastMonthEnd"}>} Sales)    "

but it does not work. When I replace 3MonthsAgo and LastMonthEnd with a random date ("1/1/2017") it does work.
Is my expression wrong?

[arulsettu]

Maybe like this Sum({<Date={">=$(Monthstart(3MonthsAgo)) <=$(Monthend(LastMonthEnd))"}>} Sales)

[AnnieV]

Unfortunately that doesn't work either 😕


when the 2 tables are not linked:

when the 2 tables are linked:

the expressions editor shows this:

[arulsettu]

Can you share the sample app and the output you are expecting?

[NitinK7]

Hi,

try like below expression

Sum({<Date={">=$(=date(MonthStart(today()-90),'DD/MM/YYYY'))<=$(=date(MonthEnd(today()),'DD/MM/YYYY'))"}>}Sales)

Thanks,

Nitin.