# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for
Did you mean:
Not applicable

## MTD - LMTD

Hi everyone

I want to calculate MTD and LMTD.

MTD:

When a date is selected and it will look for the Starting date of the Month to the selected date.

Ex: date selected is 14-02-2015 then MTD is 01-02-2015 to 14-02-2015.

LMTD:

When a date is selected and it will look for the Starting date of the Last Month to the selected date.

Ex: date selected is 14-02-2015 then LMTD is 01-01-2015 to 14-01-2015.

6 Replies
Partner

For MTD:

Sum({<Date = {">=\$(=max(MonthStart)) <=\$(=max(Date)) "} >}  Sales)

For LMTS:

MVP

Try this:

MTD

Sum({<Date = {"\$(='>=' & Date(MonthStart(Max(Date)), 'DD-MM-YYYY') & '<=' & Date(Max(Date), 'DD-MM-YYYY'))"}>}Measure)

LMTD

Sum({<Date = {"\$(='>=' & Date(MonthStart(Max(Date), -1), 'DD-MM-YYYY') & '<=' & Date(AddMonths(Max(Date), -1), 'DD-MM-YYYY'))"}>}Measure)

Not applicable
Author

Hi Sunny

This calculation is not work for my app. Result of this formule is zero.

MVP

Is your date format DD-MM-YYYY like its used in example above? or is it something else. Make sure to read this thread to understand Dates in Set Analysis

Specialist II

Hi

Try this :

MTD :

YTD

Sum({\$<[Date] = {'>=\$(=MonthStart(Today()))'}>} [Sales])

LMTD