Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

kirsten_dc
New 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