topic Using multiple dimensions in QlikView https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393172#M146642 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>(last one for this evening)</P><P></P><P>I am having a problem using multiple dimensions in a bar chart.</P><P></P><P>I have US States, and Regions in my data - each state is grouped up into a region.</P><P></P><P>When I put one dimension above the other in the dimension Tab, QV seems to think that each state appears in every region on my chart, and creates space for the bar - which is blank for regions in which the state does not exist?</P><P></P><P>Should this be possible?&nbsp; a bar chart showing sales by state, but grouped by the region of the state?&nbsp; I would then also like to colour by region...</P><P></P><P>Tom</P></BODY></HTML> Thu, 01 Nov 2012 18:17:20 GMT 2012-11-01T18:17:20Z Using multiple dimensions https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393172#M146642 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>(last one for this evening)</P><P></P><P>I am having a problem using multiple dimensions in a bar chart.</P><P></P><P>I have US States, and Regions in my data - each state is grouped up into a region.</P><P></P><P>When I put one dimension above the other in the dimension Tab, QV seems to think that each state appears in every region on my chart, and creates space for the bar - which is blank for regions in which the state does not exist?</P><P></P><P>Should this be possible?&nbsp; a bar chart showing sales by state, but grouped by the region of the state?&nbsp; I would then also like to colour by region...</P><P></P><P>Tom</P></BODY></HTML> Thu, 01 Nov 2012 18:17:20 GMT https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393172#M146642 2012-11-01T18:17:20Z Re: Using multiple dimensions https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393173#M146643 <HTML><HEAD></HEAD><BODY><P>Could you post a qvw with your problem?</P></BODY></HTML> Thu, 01 Nov 2012 19:20:39 GMT https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393173#M146643 Clever_Anjos 2012-11-01T19:20:39Z Re: Using multiple dimensions https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393174#M146644 <HTML><HEAD></HEAD><BODY><P>I'm not sure if it will work, but what happens if you create and add a hierarchical dimension as a dimension and expand all nodes? (Not hierarchical group)</P><P></P><P>Best regards</P><P>Vegar Lie Arntsen</P><P>QlikView consultant at egbs consulting ab</P><P><SPAN>Blog (in Swedish): </SPAN><A class="jive-link-external-small" href="http://bi-effekten.se">http://bi-effekten.se</A></P></BODY></HTML> Thu, 01 Nov 2012 19:29:36 GMT https://community.qlik.com/t5/QlikView/Using-multiple-dimensions/m-p/393174#M146644 Vegar 2012-11-01T19:29:36Z