Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Akina0929
Creator
Creator

How to calculate MTD Run rate and YTD Run rate in qliksense

Hi Community,

I want to implement below formulas in qlik

MTD Run Rate---MTD  Days passed /total MTD days

YTD Run Rate--YTD Day passed / total YTD Days

team please help me to create expressions  for above formulas

 

Thanks in Advance,

Labels (1)
1 Reply
Mark_Little
Luminary
Luminary

Hi @Akina0929 

These are two flags i pretty much create in all my app calendars, this then allows me to do analysis on dates much quicker. 

IF(YEAR(TempDate)= YEAR(TODAY(1)) AND MONTH(TempDate)= MONTH(TODAY(1)) AND TempDate <= TODAY(1),1) AS F_MTD,

IF(YEAR(TempDate)= YEAR(TODAY(1)) AND TempDate <= TODAY(1),1) AS F_CAL_YTD,

 

With these flags you can do following

COUNT(F_MTD) will give you the MTD days