Get the values of only selected dimension

[#1]

I am using a straight table to  populate country,count and clicks.I want to show the sum of clicks obtained for selected countries.I am using the expression 'count({<Country={'USA','India','UK','Canada'}>}Country)' to populate the count column and this  show only the selected countries and when i add another expression 'sum(clicks)' to show sum of clicks each selected country got,then  table shows count of all the countries from my source excel.Below attached is my sample qlikview file

[Gysbert_Wassenaar · Accepted solution]

Add the same filter to the sum expression too: sum({<Country={'USA','India','UK','Canada'}>}clicks)

[Anonymous]

You need the set analysis on the 2nd expression as well.

     Sum({<Country={'USA','India','UK','Canada'}>}Clicks)

[#4]

Hi thank you for the help it worked for me

[#5]

Hi thank you for the help