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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Siddhanttomar
Contributor
Contributor

set analysis

How to find the Year till date(YTD) with the help of set analysis?

Labels (5)
3 Replies
Bunim
Contributor III
Contributor III

aggr(only({<Year={"<$(=year(date))"}>}Year),Year)

Iswarya_
Creator
Creator

Hi @Bunim 

YTD:

sum({$<Year=,Month=, DateFieldName={'>=$(=YearStart(Today()))<=$(=Today())'}>}Revenue)