topic Re: Group Dimension Dynamic Axes in QlikView

Group Dimension Dynamic Axes

Wed, 05 Aug 2015 17:38:26 GMT

Hello,

I was wondering if anyone would know how can i make my Axes dynamic, in the type of Max(Aggr(Exp,Dim)), but when that Dim is a group.

I cant define there a particular dimension because its a group, and when the selected dimension on the group switches, i would like to swtich the Dim as well.

Is there any way to do this?

Thank you

Re: Group Dimension Dynamic Axes

Kushal_Chawda — Wed, 05 Aug 2015 17:48:20 GMT

Use this

Max(Aggr(Exp,$(=getcurrentfield([YourCyclicGroupName]))))

Re: Group Dimension Dynamic Axes

lironbaram — Wed, 05 Aug 2015 17:50:12 GMT

you could use a variable

let call is vDim you set the variable with this expression

=Getcurrentfield(yourdim)

and the axes function will be Max(Aggr(Exp,vDim))

Re: Group Dimension Dynamic Axes

Wed, 05 Aug 2015 18:53:52 GMT

thanks alot