topic How to create Dynamic Scaling based on selected Dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-create-Dynamic-Scaling-based-on-selected-Dimension/m-p/1179828#M382511 <HTML><HEAD></HEAD><BODY><P>I am working with a trellis chart where the user can select a range of dimensions to flip in and out dynamically.&nbsp; Based on the dimension selection (i.e. Zone) I would want to scale the data by X but when I drill in on a Zone and flip the dimension to Branch as another example, I want to then Scale the data by Y.</P><P></P><P>Is there a formula or something that can help me do this?</P><P></P><P>Thanks for any assistance you can provide!!</P></BODY></HTML> Fri, 09 Sep 2016 16:27:56 GMT 2016-09-09T16:27:56Z How to create Dynamic Scaling based on selected Dimension https://community.qlik.com/t5/QlikView/How-to-create-Dynamic-Scaling-based-on-selected-Dimension/m-p/1179828#M382511 <HTML><HEAD></HEAD><BODY><P>I am working with a trellis chart where the user can select a range of dimensions to flip in and out dynamically.&nbsp; Based on the dimension selection (i.e. Zone) I would want to scale the data by X but when I drill in on a Zone and flip the dimension to Branch as another example, I want to then Scale the data by Y.</P><P></P><P>Is there a formula or something that can help me do this?</P><P></P><P>Thanks for any assistance you can provide!!</P></BODY></HTML> Fri, 09 Sep 2016 16:27:56 GMT https://community.qlik.com/t5/QlikView/How-to-create-Dynamic-Scaling-based-on-selected-Dimension/m-p/1179828#M382511 2016-09-09T16:27:56Z Re: How to create Dynamic Scaling based on selected Dimension https://community.qlik.com/t5/QlikView/How-to-create-Dynamic-Scaling-based-on-selected-Dimension/m-p/1179829#M382512 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>if you're using dimension groups, then you can use limit expressions for your axes like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14734569474706433 jive_text_macro" jivemacro_uid="_14734569474706433"> <P>Pick(Match(GetCurrentField(YourGroupName),'Zone','Branch'),X,Y)</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 09 Sep 2016 21:35:52 GMT https://community.qlik.com/t5/QlikView/How-to-create-Dynamic-Scaling-based-on-selected-Dimension/m-p/1179829#M382512 MarcoWedel 2016-09-09T21:35:52Z