topic Re: MonthStart & Today() - Substracting days in QlikView

MonthStart & Today() - Substracting days

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I hope someone can help me.

I have below expression, where I'm trying to substract XX numbers of days from MonthStart of Today().

However it doesn't return the correct amount. It seems like it's including to many days.

Sum({$<BOOKING_DATE = {">=$(=MonthStart(TODAY() - 16)) <=$(=MonthStart(TODAY())))"}>} NET)

So basically I'm trying to get this date range e.x [15-09-2017] - [01-10-2017].

Thanks.

Regards

Stefan

Re: MonthStart & Today() - Substracting days

Anil_Babu_Samineni — Fri, 13 Oct 2017 08:15:56 GMT

Does this works?

Sum({<BOOKING_DATE = {"=BOOKING_DATE >= MonthStart(Today())-16 AND BOOKING_DATE <= MonthStart(Today())"}>} NET)

Note - Make sure about Date format for BOOKING_DATE and Today(). Try to check using text box..

Re: MonthStart & Today() - Substracting days

RonaldDoes — Fri, 13 Oct 2017 08:19:20 GMT

MonthStart(TODAY() - 16)

will do just that, give you the MonthStart for the date 16 days ago (so for the first 16 days of the month, the monthstart of the previous month, and from the 17th of each month, just the montstart of the current one).

What you want here is:

MonthStart(Today())-16

Re: MonthStart & Today() - Substracting days

Anonymous — Fri, 13 Oct 2017 08:50:45 GMT

Hi Anil

That was "easy".

And yes it works perfectly.

Thanks a lot.

Re: MonthStart & Today() - Substracting days

Anonymous — Fri, 13 Oct 2017 08:51:53 GMT

Hi Ronald

Yes of course. That makes sense. It's all about the parenthesis.

Thanks for the answer. I will keep that in mind.