Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Akina0929
Creator
Creator

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

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
vinieme12
Champion III
Champion III

YTD

= sum({<Datefield={">=$(=Date(yearstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}>}Measurefield)

 

MTD

= sum({<Datefield={">=$(=Date(monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}>}Measurefield)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.