Solved: Show Total Without Select Field - Qlik Community

pgalvezt2021 · ‎2023-11-22

Hello !!!!

I would like to show the total sales for each Country. When I select a Country, and in my formula I have a TOTAL within the Set Analysis and it shows me well. but when I show all the Countries it doesn't show me the total by country. The final result I want a table that shows me all the totals by country without filtering Countries. I Put examples for Italy and Chile.

Thanks !!!!

kaushiknsolanki · ‎2023-11-22

Try this.

Sum(total <Country>Actual)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2023-11-22

Try this.

Sum(total <Country>Actual)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!