# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Contributor II

## Sum Values Irrespective of one field

Hello, I want to have the Market share of each company by country, and I don't know how to do this calculation using set analysis.

Any suggestions?

Table1: Contains the total amount by company and country

 Country Company1 Company2 Company3 Total C1 3000 2500 900 6400 C2 4000 3000 1500 8500 C3 3500 1400 800 5700 C4 2000 1000 800 3800 C5 6000 4500 2600 13100

What I want is to have a table like the following, which contains the amount of each cell in table1 over the total by country

Table2:

 Country Company1 Company2 Company3 C1 47% 39% 14% C2 47% 35% 18% C3 61% 25% 14% C4 53% 26% 21% C5 46% 34% 20%
1 Solution

Accepted Solutions

@p_1  if your data input is like :

you can use pivot table with:

dimension: country and company

measure :

``sum(Value)/sum(Total<Country> Value)``

output:

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
2 Replies

@p_1  if your data input is like :

you can use pivot table with:

dimension: country and company

measure :

``sum(Value)/sum(Total<Country> Value)``

output:

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Contributor II
Author

Thank You @Taoufiq_Zarra , if i want to add year to my set analysis expression how should i write it?

sum({<year = {2020}>} Value) / sum({<year = {2020}, Country>} total Value)?