Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijayqlik4171
Contributor III
Contributor III

i need YTD,PYTD,MTD,PMTD,QTD,PQTD FORMULAS

 
2 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Pallav
Contributor II
Contributor II

PMTD - Sum({<DateID={"$(='>=' & Date(Monthstart(Max(DateID),-1),'MM/DD/YYYY') & '<=' & Date(Monthend(Addmonths(Max(DateID),-1)),'MM/DD/YYYY'))"}>}Sales)

 

PYTD - Sum({<DateID={"$(='>=' & Date(Yearstart(Max(DateID),-1),'MM/DD/YYYY') & '<=' & Date(Addyears(Max(DateID),-1),'MM/DD/YYYY'))"}>}Sales)

PQTD - Sum({<DateID={"$(='>=' & Date(Quarterstart(Max(DateID),-1),'MM/DD/YYYY') & '<=' & Date(Quarterend(Quarterstart(Max(DateID),-1)),'MM/DD/YYYY'))"}>}Sales)

 

QTD - Sum({<DateID={"$(='>=' & Date(Quarterstart(Max(DateID)),'MM/DD/YYYY') & '<=' & Date(Max(DateID),'MM/DD/YYYY'))"}>}Sales)

 

MTD - Sum({<DateID={"$(='>=' & Date(Monthstart(Max(DateID)),'MM/DD/YYYY') & '<=' & Date(Max(DateID),'MM/DD/YYYY'))"}>}Sales)

 

YTD - Sum({<DateID={"$(='>=' & Date(Yearstart(Max(DateID)),'MM/DD/YYYY') & '<=' & Date(Max(DateID),'MM/DD/YYYY'))"}>}Sales)