Aggr SumTotal

Thu, 10 Dec 2015 17:52:28 GMT

I am trying to do a total sum of an aggregation without success.

I have 3 variables:

Country
Region
Population

I would like to have always in one column the sum of population of all Countries and Regions at continent level, regardless of being selected.

Therefore, in case of not selecting anything, the figure should be 1,934 (note that the sum of population is not a simple sum but a aggregated sum of region and country) and in case of selecting a region or country, the sum should continue being 1,934.

The calculus being used:

sum( total <Continent> {<Country>}

aggr( Population,Country, Region ))

However, if I select 1 country, I see the data of the country (0,24), not the total (1,934) that I want.

Please find attached thhe document where I am trying to obtain this calculus.

Thank you so much.

Re: Aggr SumTotal

sunny_talwar — Thu, 10 Dec 2015 18:06:00 GMT

Try this:

=Sum(TOTAL <Continent> {<Country>} Aggr(Only({<Country>}Population), Country, Region))

Re: Aggr SumTotal

Thu, 10 Dec 2015 19:04:05 GMT

Wonderful! this is working perfectly!!

thank you!

Re: Aggr SumTotal

sunny_talwar — Thu, 10 Dec 2015 19:09:06 GMT

Awesome

topic Re: Aggr SumTotal in QlikView

Aggr SumTotal

Re: Aggr SumTotal

Re: Aggr SumTotal

Re: Aggr SumTotal