percentage counting

[Krissu]

Hi!

I have query results; some values are positive, and some are negative. There are different number of answers in each year, so I need % of see what the difference in each year is. I have problem with percentage counting for each year separately. If I use total, then the % will be the percentage of all these 3 years results. I made an example with Excel of the result what I want to have. Any ideas how I can do this in Qlik Sense?

WBR Krista

[hic · Accepted solution]

I cannot see what your field names are, but you should in principle use

Count(Answer) / Count(total <Year> Answer)

[Krissu]

Hi Henric! Thank you so much! It works!

Wbr Kirsta