Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kirsten_dc
Partner - Contributor II
Partner - Contributor II

Expression does not show sum of rows

Dear community,

I have created a small complex expression which does not show the sum of rows.

How can I solve this problem?

This is the expression:

(

  Sum(

  Aggr(Sum({$<gYear={$(=Max(gYear))}>}ArticleAmount),Article,ArticleGroup,Depart,Group,TPBrn)

  /

  Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear))}>} DP_DPax),TPBrn)

  )

  -

  Sum(

  Aggr(Sum({$<gYear={$(=Max(gYear)-1)}>}ArticleAmount),Article,ArticleGroup,Depart,Group,TPBrn)

  /

  Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear)-1)}>} DP_DPax),TPBrn)

  )

)

* Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear))}>} DP_DPax),TPBrn)

SumOfTotalRow.JPG

Thanks in advance

Kirsten

0 Replies