Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

How to get Totals while using aggr in Qliksense

Hi ,

I am grouping my expression according to a column using 'aggr' in the expression editor. I am not able to get any value in Totals column.

For example,

I want to display aggr(sum(aggr(sum(revenue),city)),country), how can I get the corresponding expression to flash in the Totals row?

  

CountryCityRevenue($ mn)
IndiaDelhi12
IndiaGurgaon4
IndiaNoida11
IndiaPune17
IndiaHyderabad5
IndiaBanglore7
USANew York13
USALA3
USADetroit2
USAWashington15

I want my final aggregation with respect to countries

1 Solution

Accepted Solutions
sunny_talwar

Why not just use Sum(revenue)? or may be this

Sum(Aggr(Sum(revenue), country, city))

View solution in original post

7 Replies
sunny_talwar

Why not just use Sum(revenue)? or may be this

Sum(Aggr(Sum(revenue), country, city))

shilpan
Partner Ambassador
Partner Ambassador

You can have naked aggr expression to show total so as Sunny mentioned, always have an outer aggregation such as sum.

HIC has written an excellent article on how AGGR works.

Set Analysis in the Aggr function

zebhashmi
Specialist
Specialist

i think

sum(aggr(sum(aggr(sum(revenue),city,country)),country))

wdchristensen
Specialist
Specialist

Might also verify that Revenue is actually of type number number and not coming in your load as a text.


https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/LogicalFunctio...

IsNum(Revenue) should return -1. If it returns Zero you are dealing with text and your math function won't work.

dwforest
Specialist II
Specialist II

No need to aggr sum of sums.

if the revenue is in the data model at the city, country level or lower (like a time dimenison), a straight sum with city and country as dimensions would sum by those keys.

zebhashmi
Specialist
Specialist

unless if you want something else than the sum

only Sum(Revenue) is the same