https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983042#M1221087 <P>Hi!</P> <P>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?</P> <P>WBR Krista</P> Tue, 20 Sep 2022 10:24:32 GMT Krissu 2022-09-20T10:24:32Z https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983042#M1221087 <P>Hi!</P> <P>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?</P> <P>WBR Krista</P> Tue, 20 Sep 2022 10:24:32 GMT https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983042#M1221087 Krissu 2022-09-20T10:24:32Z https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983084#M1221088 <P>I cannot see what your field names are, but you should in principle use</P><P>Count(Answer) / Count(total &lt;Year&gt; Answer)</P> Tue, 20 Sep 2022 11:16:46 GMT https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983084#M1221088 hic 2022-09-20T11:16:46Z https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983105#M1221089 <P>Hi Henric! Thank you so much! It works!</P> <P>Wbr Kirsta</P> Tue, 20 Sep 2022 11:59:38 GMT https://community.qlik.com/t5/QlikView/percentage-counting/m-p/1983105#M1221089 Krissu 2022-09-20T11:59:38Z