Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Do we have MTD and YTD functions?

Hi Everyone,

can any one let me know that do we have MTD (Month to date) and YTD (Year to Date) Functions existed .

if yes please let me know the way to use them.

thanks in advance

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Such functions aren't available. You need to use set analysis and/or flags within the script for it. Here are two examples how it could be developed/used:

Previous YTQ, QTD, MTD and WTD

Calendar with flags making set analysis so very simple

- Marcus