Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
YTD
= sum({<Datefield={">=$(=Date(yearstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}>}Measurefield)
MTD
= sum({<Datefield={">=$(=Date(monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"}>}Measurefield)