Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Vinay ,

Please try below:

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

Thanks,

Arvind Patil