Month to date

[tracer]

Dear all,

I want to use month to date function for my report. i'm using autocalender. The issue i'm facing is that my report must show date till previous day.

as now i have only data for June, I'm using bellow expressiona and it works fine.

Sum({<[Stroškovno mesto]={'7'},[Datum.autoCalendar.Date]={"$(='<'& (Today()))"}>}[Sales)])

the problem will be on 2nd of July, as may expression will show also data for June, which I do not want.

Thank you in advance for your suggestions.

kind regards,

Matej

[Or]

You might want to consider using the built-in function, InMonthToDate()

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...

[tracer]

Thank you for your response.

I want to use it, but I'm not sure how to set an expression to give me
Month to date on base date today - 1 day.

Kind regards

Matej

[Or]

Presumably, InMonthToDate(YourDate,Today()-1)? You might also want to combine this with InMonth(YourDate,Today()-1) if you're just looking for the current month.

[matejb]

Could you be so kind and  advise how to change bellow scipt

Sum({<[Stroškovno mesto]={'7'},[Datum.autoCalendar.Date]={"$(='<'& (Today()))"}>}[Sales)])