Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Usage of "MTD Current Month" vs "Current Month"

What are the use cases where I should use MTD Current Month vs Current Month?


Looking at my data for the current month, MTD Current Month and Current Month return the same value. I'm guessing you would likely use Current Month in an expression to do something like budget vs actual to see if you're on track, but I'm not sure.

Reference - [Creating Calendar Measures].

Kind Regards,

Vinny

1 Reply
Partner
Partner

Re: Usage of "MTD Current Month" vs "Current Month"

Hi Vinay ,

Please try below:

Sum({<Date={'>= $(=monthstart(max(Date))) <= $ (=max(Date))'}>}Sales)

Thanks,

Arvind Patil