Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Hi,
By Firstsortedvalue()
https://community.qlik.com/t5/New-to-Qlik-Sense/Group-BY-Year-Aggr-Help/td-p/1701729
Regards,
Durgadevi