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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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