topic Re: aggr function in QlikView

aggr function

Mon, 26 Jan 2026 16:26:21 GMT

Hi.I faced a problem.

I have tw fields Subregion and Product. Expr is

cout({$<CalendarYearQuarter={'2013-Q1'}>} distinct CustINN )

In total we see 3362. How to write expression which will calculate this total sum in front of every product.

What I would like to get is

This expression aggr( sum(Expr),Subregion ) doesn`t work.

Re: aggr function

alexandros17 — Thu, 17 Apr 2014 09:27:24 GMT

Try this

aggr(Nodistinct sum(Expr),Subregion, Product )

Sum( aggr( sum(Expr),Subregion ))

Re: aggr function

MK_QSL — Thu, 17 Apr 2014 09:31:32 GMT

Full Total

SUM(TOTAL Expr)

For SubRegion wise Total

SUM(TOTAL <SubRegion> Expr)

Re: aggr function

Thu, 17 Apr 2014 09:45:42 GMT

It doesn`t work too. It shows 0 or -(NULL)

Re: aggr function

Thu, 17 Apr 2014 09:45:58 GMT

doesn`t help

Re: aggr function

alexandros17 — Thu, 17 Apr 2014 09:47:04 GMT

can you attach your document?

Re: aggr function

MK_QSL — Thu, 17 Apr 2014 09:47:21 GMT

What is expr...

means what is the expression behind expr?

Re: aggr function

sujeetsingh — Thu, 17 Apr 2014 09:48:37 GMT

try using sum({1}Field)

Re: aggr function

Thu, 17 Apr 2014 09:52:52 GMT

This expression aggr(count(DISTINCT CustINN),Subregion) works

but it show result next to only one product((

Is it possible to correct it?

Re: aggr function

Thu, 17 Apr 2014 09:53:32 GMT

cout({$<CalendarYearQuarter={'2013-Q1'}>} distinct CustINN )

Re: aggr function

Thu, 17 Apr 2014 09:53:40 GMT

cout({$<CalendarYearQuarter={'2013-Q1'}>} distinct CustINN )

Re: aggr function

MK_QSL — Thu, 17 Apr 2014 09:57:11 GMT

aggr(count({1}DISTINCT CustINN),Subregion)

Re: aggr function

MK_QSL — Thu, 17 Apr 2014 10:01:36 GMT

Full Total

count(TOTAL {<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

For SubRegion wise Total

count(TOTAL <Subregion>{<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

Re: aggr function

Thu, 17 Apr 2014 10:35:45 GMT

Manish, you are geneus) It Works! Thank you very much)

Re: aggr function

MK_QSL — Thu, 17 Apr 2014 10:37:29 GMT

Glad that my answer helps you.

Kindly close this thread by selecting correct/helpful answer so that others having the same problem can use this thread.

Re: aggr function

Thu, 17 Apr 2014 11:41:03 GMT

Manish, one more question. I didn`t notice that the filter was on Subregion. So this expression

count(TOTAL <Subregion>{<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

calculate total amount, but how to aggregate it by Subregion? Thanks

Re: aggr function

MK_QSL — Thu, 17 Apr 2014 11:54:34 GMT

Full Total

count(TOTAL {<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

For SubRegion wise Total

count(TOTAL <Subregion>{<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

UPDATE: ONLY HELPFUL ANSWER?

Check enclosed file...