https://community.qlik.com/t5/App-Development/Sum-values-based-on-selected-countries/m-p/1747800#M57492 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/65458">@Kunkulis</a>&nbsp;</P><P>Any chance you can share a sample of the data? I also assume that the country and Year in the $ Expansion are variables? What are the calculations for those?&nbsp;</P> Mon, 28 Sep 2020 16:12:37 GMT Steven_Haught 2020-09-28T16:12:37Z https://community.qlik.com/t5/App-Development/Sum-values-based-on-selected-countries/m-p/1747745#M57481 <P>Hello,</P><P>I have selected 3 countries:</P><UL><LI>Denmark (0.05)</LI><LI>Sweden (0.1)</LI><LI>Germany(0.5)</LI></UL><P>The numbers in brackets are the ones I want to Sum, but I keep getting 0<BR />Also, please keep in mind, that there are way more countries in the app, so the SUM has to be dynamic and change on the selections.</P><P>Currently I am trying this formula, which seems correct, but, as I said, I keep getting a 0</P><LI-CODE lang="markup">=Sum({&lt;Country={'$(=Country)'},Year={'$(=Year)'}&gt;}Number)</LI-CODE><P>I tried&nbsp;</P><LI-CODE lang="markup">=Sum({&lt;Country&gt;}Number)</LI-CODE><P>Which did work, but it gave me (what I assume) was the whole sum</P><P>&nbsp;</P><P>Thank you in advance</P> Sat, 16 Nov 2024 01:22:06 GMT https://community.qlik.com/t5/App-Development/Sum-values-based-on-selected-countries/m-p/1747745#M57481 Kunkulis 2024-11-16T01:22:06Z https://community.qlik.com/t5/App-Development/Sum-values-based-on-selected-countries/m-p/1747800#M57492 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/65458">@Kunkulis</a>&nbsp;</P><P>Any chance you can share a sample of the data? I also assume that the country and Year in the $ Expansion are variables? What are the calculations for those?&nbsp;</P> Mon, 28 Sep 2020 16:12:37 GMT https://community.qlik.com/t5/App-Development/Sum-values-based-on-selected-countries/m-p/1747800#M57492 Steven_Haught 2020-09-28T16:12:37Z