Qlik Community

Ask a Question

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 
Search instead 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
shraddha_g
Partner
Partner

For MTD:

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

For LMTS:

Sum({<Date ={" >=$(=date(addmonths(max(MonthStart), - 1)))<=$(=date(addmonths(max(Date),-1)))"}>} Sales)

sunny_talwar

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.

sunny_talwar

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

brunobertels
Specialist II
Specialist II

Hi

Try this :

MTD :

YTD

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

LMTD

Sum({$<[Date] = {'>=$(=Date(addmonth(monthstart(Today()),-1)))<$(=Date(addmonth(Today(),-1)))'}>} [Sales])

shraddha_g
Partner
Partner

also you can try:

For MTD:

Sum({<Date = {">=$(=max(MonthStart)) <=$(=max(Date)) "},Month=,Year= >}  Sales)

For LMTS:

Sum({<Date ={" >=$(=date(addmonths(max(MonthStart), - 1)))<=$(=date(addmonths(max(Date),-1)))"},Month=,Year=>} Sales)