Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to perform YTD and PYTD without selecting any date

how  to perform YTD and PYTD without selecting any date

2 Replies
ramoncova06
Partner - Specialist III
Partner - Specialist III

you could try something like the following

=sum( {$<Date = {">=$(=floor(yearstart(Max(Date)))<=$(=Max(Date)) "} >} Value)

=sum( {$<Date = {">=$(=floor(yearstart(addmonth(Max(Date),-12)))<=$(=addmonth(Max(Date),-12)) "} >} Value)

Not applicable
Author

i mean wat happend