Dimension Groups

[fcecconi]

I have create a dimension group that cycles throw Year, Quarter, Month.  I am trying to create a percentage bar chart, the chart looks like it is working, but when I examine the expression it says there is an error.

Here is my expression

Sum(AENETWR) /  Sum (TOTAL <OrderDate> AENETWR)

OrderDate is my Dimension Group.

thanks!

[sunny_talwar]

You cannot use group name as a field name within < >

[prabhu0505]

TOTAL keyword by default considers the active dimension so below expression should work fine.

Sum(AENETWR) /  Sum (TOTAL AENETWR)

[rwunderlich · Accepted solution]

You can substitute in the current group field with:

Sum(AENETWR) /  Sum (TOTAL <$(=GetCurrentField(OrderDate))> AENETWR)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[fcecconi]

Thanks Rob!

[sunny_talwar]

I never knew that this would work. Thanks for sharing this idea Rob.