Count Year YEAR

[Vittore8]

Hi,there is a column

how can I get this result

[Or]

The result seems to always just be 1, so.. add a column with the formula being =1?

[Vittore8]

@Or 
Date(Aggr(if(Sum({<state={"successful"},main_category={"Food"}>} usd_pledged_real / backers)>=1000,[launched]),[launched]), 'YYYY') -- I get this column with this expression

how can I add a column with the formula being =1?

[Or]

You've already tried asking that in previous threads, and I still don't understand the question...

[Vittore8]

@Or ,  there is a column

I'm trying to get the following result

for each year, calculate its number

[thadke]

Hi @Vittore8 ,

You can try below:

This is working for me.

For more details, you can check: https://community.qlik.com/t5/New-to-Qlik-Sense/COUNT-VALUES-IN-DIFFERENT-COLUMNS/td-p/40788

Like if useful / select as best answer if your issue is resolved.

[thadke]

Hi @Vittore8 ,

You can try below:

This is working for me

For more details, you can refer: https://community.qlik.com/t5/New-to-Qlik-Sense/COUNT-VALUES-IN-DIFFERENT-COLUMNS/td-p/40788

Like if useful / select as best answer if your issue is resolved.