topic Sum of some particular countries using set analysis in QlikView

Sum of some particular countries using set analysis

Saiteja1 — Wed, 04 May 2022 13:13:11 GMT

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

Re: Sum of some particular countries using set analysis

rwunderlich — Wed, 04 May 2022 13:29:57 GMT

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

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

Re: Sum of some particular countries using set analysis

Saiteja1 — Wed, 04 May 2022 13:39:04 GMT

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 ??

Re: Sum of some particular countries using set analysis

Vegar — Wed, 04 May 2022 14:31:35 GMT

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)

Re: Sum of some particular countries using set analysis

Saiteja1 — Wed, 04 May 2022 16:11:37 GMT

Thanks Vegar

Re: Sum of some particular countries using set analysis

d33paklala — Thu, 27 Jul 2023 14:11:04 GMT

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