topic Re: Dimension Groups in QlikView

Dimension Groups

fcecconi — Wed, 11 Nov 2015 17:04:58 GMT

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!

Re: Dimension Groups

sunny_talwar — Wed, 11 Nov 2015 17:20:16 GMT

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

Re: Dimension Groups

prabhu0505 — Wed, 11 Nov 2015 17:30:15 GMT

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

Sum(AENETWR) / Sum (TOTAL AENETWR)

Re: Dimension Groups

rwunderlich — Wed, 11 Nov 2015 18:04:21 GMT

You can substitute in the current group field with:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Dimension Groups

fcecconi — Wed, 11 Nov 2015 18:24:43 GMT

Thanks Rob!

Re: Dimension Groups

sunny_talwar — Wed, 11 Nov 2015 19:00:46 GMT

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