topic Re: Aggr in Calculated Dimension v Expression in QlikView

Aggr in Calculated Dimension v Expression

johngouws — Sat, 29 Mar 2014 04:13:43 GMT

Good morning,

I am having an issue achieving the required result in a Calculated Dimension.

In the attached qvw there are 3 objects on the left, straight tables, using aggr in the expression. Regardless of which Dimensions are used, the result is correct and balances to the sample report.

However, what I am trying to achieve is get the same result, as a single number, at a "Group" level, in a calculated dimension, in the straight table on the right.

I appreciate any and all suggestions in this regard.

Thank you in advance - John

Re: Aggr in Calculated Dimension v Expression

Anonymous — Sat, 29 Mar 2014 04:28:46 GMT

Try as your calculated Dimension:

=AGGR(SUM(Aggr(

If(sum((Qty * Value) + Debits + Credits) > 0, Sum(OpeningFloat) ),

Group, Property ,Name)),Group)

Re: Aggr in Calculated Dimension v Expression

johngouws — Sat, 29 Mar 2014 07:12:07 GMT

Hello Michael.

Thank you, that works perfectly.

John