Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I cannot see what your field names are, but you should in principle use
Count(Answer) / Count(total <Year> Answer)
I cannot see what your field names are, but you should in principle use
Count(Answer) / Count(total <Year> Answer)
Hi Henric! Thank you so much! It works!
Wbr Kirsta