topic Qlik Sense measure expression between two dates in Visualization and Usability

Qlik Sense measure expression between two dates

AnnieV — Sat, 16 Nov 2024 00:26:24 GMT

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?

Re: Qlik Sense measure expression between two dates

arulsettu — Tue, 23 Jun 2020 09:22:33 GMT

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

Re: Qlik Sense measure expression between two dates

AnnieV — Tue, 23 Jun 2020 10:47:15 GMT

Unfortunately that doesn't work either 😕

when the 2 tables are not linked:

when the 2 tables are linked:

the expressions editor shows this:

Re: Qlik Sense measure expression between two dates

arulsettu — Tue, 23 Jun 2020 13:37:00 GMT

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

Re: Qlik Sense measure expression between two dates

NitinK7 — Tue, 23 Jun 2020 13:50:51 GMT

Hi,

try like below expression

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

Thanks,

Nitin.