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: 
Vittore8
Creator
Creator

Aggr GroupBY Year Help Expression

Vittore8_0-1589403110380.png

I formed a column, but how i can return only 2016 year

My Expression

=Date(Aggr(if(Sum({<state={"successful"},main_category={"Food"}>} usd_pledged_real / backers)>=1000,[launched]),[launched]), 'YYYY')

Labels (1)
1 Reply
Durgadevikumar
Partner - Contributor III
Partner - Contributor III