Sum of some particular countries using set analysis

[Saiteja1]

Hi..,

I have a scenario

we have two fields

Country ,Sales
India, 1000
UK ,3000
Ireland ,5000
Japan ,2000
Japan ,9000
APAC ,2000
UKI ,3000
AFR ,7000
Uganda, 8000

I need sum of sales of Japan,UKI,AFR,Ireland using set analysis

Thanks in advance

[rwunderlich · Accepted solution]

Sum({<Country={'Japan','UKI','AFR','Ireland'}>}Sales)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Saiteja1]

Hi rwunderlick,

Thanks for your solution 

if we have 10 to 20 countries we can write like your solution but if we have more than 50 countries then ??

[Vegar · Accepted solution]

If you have many countries you might consider creating a field/flag in the data model for grouping them together. Consider adding an Country dimension to your data model.

Country , inKpiCountry
India, No
UK , No 
Ireland ,Yes 
Japan ,Yes 
APAC ,No 
UKI ,Yes 
AFR ,Yes 
Uganda, No

Then use the following expression:

Sum({<inKpiCountry={'Yes'}>}Sales)

[Saiteja1]

Thanks Vegar

[d33paklala]

Never hardcoded the country names. Either create a variable or create a flag as vegar suggested.