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: 
Not applicable

aggr function

Hi.I faced a problem.

1.png

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

1.png

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

16 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try this

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


or


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

MK_QSL
MVP
MVP

Full Total

SUM(TOTAL Expr)

For SubRegion wise Total

SUM(TOTAL <SubRegion> Expr)

Not applicable
Author

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

Not applicable
Author

doesn`t help

alexandros17
Partner - Champion III
Partner - Champion III

can you attach your document?

MK_QSL
MVP
MVP

What is expr...

means what is the expression behind expr?

sujeetsingh
Master III
Master III

try using sum({1}Field)

Not applicable
Author

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

but  it show result next to only one product((

Is it possible to correct it?1.png

Not applicable
Author

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