topic Re: sum across an column in QlikView

sum across an column

Anonymous — Tue, 13 Jan 2015 10:17:26 GMT

hi,

i am looking to sum across all values in the last column (# of Ads)

my goal is to sum all values in the last column, like this:

is there a waqy to do this?

Re: sum across an column

Gysbert_Wassenaar — Tue, 13 Jan 2015 10:19:40 GMT

sum( total [# of Ads])

Re: sum across an column

Anonymous — Tue, 13 Jan 2015 10:26:25 GMT

it's an id column, so i would like to count it (instead of sum it),

but when i use count, results are the same...

Re: sum across an column

Gysbert_Wassenaar — Tue, 13 Jan 2015 10:29:40 GMT

Perhaps sum(total aggr(count([# of Ads]),[QlickSourceDesc]))

Re: sum across an column

Anonymous — Tue, 13 Jan 2015 10:34:26 GMT

worked like a charm!

can you elaborate on it?

i understand the aggr function,

but i don't understand how it works when nested in a total function

Re: sum across an column

Gysbert_Wassenaar — Tue, 13 Jan 2015 10:55:19 GMT

The aggr function works exactly the same as without the total keyword. The total keyword just causes the sum to be calculated disregarding the dimension boundaries of your chart.

Re: sum across an column

nikhilgarg — Tue, 13 Jan 2015 11:15:46 GMT

Hey,

count([# of Ads]) will be equal to number of [QlickSourceDesc] .

Isn't it ??

Thanks

Re: sum across an column

Anonymous — Tue, 13 Jan 2015 11:30:29 GMT

now my problem is that it disregards other dimensions in my chart,

i have tried to drop the "tota" but it doesn't give me any result,

please see:

sum(aggr(count([Ad Counter]), ClickSourceDesc))

Re: sum across an column

Gysbert_Wassenaar — Tue, 13 Jan 2015 11:43:23 GMT

Maybe sum(total <[Year-Month]> aggr(count([Ad Counter]), ClickSourceDesc))