topic How to switch the dimensions in QlikView? in QlikView https://community.qlik.com/t5/QlikView/How-to-switch-the-dimensions-in-QlikView/m-p/294646#M1200401 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to create a stacked bar for prices of a group of product.</P><P>Dimension: product name</P><P>Expression: avg(price)</P><P></P><P>Now I get a graph with product name along the X axis, with bar = avg(price).</P><P>Like:</P><P>Price (product1), Price(product2), Price (product3)</P><P>However, I want to put price as an dimension, and treat each product name as a series of the stacked bar.</P><P>Like:</P><P>Price(product 1)</P><P>Price (product2)</P><P>Price (product3)</P><P>...</P><P></P><P>Thanks in advance!</P><P></P><P>Danni</P></BODY></HTML> Thu, 16 Dec 2010 18:13:23 GMT 2010-12-16T18:13:23Z How to switch the dimensions in QlikView? https://community.qlik.com/t5/QlikView/How-to-switch-the-dimensions-in-QlikView/m-p/294646#M1200401 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to create a stacked bar for prices of a group of product.</P><P>Dimension: product name</P><P>Expression: avg(price)</P><P></P><P>Now I get a graph with product name along the X axis, with bar = avg(price).</P><P>Like:</P><P>Price (product1), Price(product2), Price (product3)</P><P>However, I want to put price as an dimension, and treat each product name as a series of the stacked bar.</P><P>Like:</P><P>Price(product 1)</P><P>Price (product2)</P><P>Price (product3)</P><P>...</P><P></P><P>Thanks in advance!</P><P></P><P>Danni</P></BODY></HTML> Thu, 16 Dec 2010 18:13:23 GMT https://community.qlik.com/t5/QlikView/How-to-switch-the-dimensions-in-QlikView/m-p/294646#M1200401 2010-12-16T18:13:23Z How to switch the dimensions in QlikView? https://community.qlik.com/t5/QlikView/How-to-switch-the-dimensions-in-QlikView/m-p/294647#M1200402 <HTML><HEAD></HEAD><BODY><P>This isn't tested, but a bar chart will only stack once you have 2 dimensions and one expression so add a calculated dimension like ='dim' which is a fixed string with the second dimension product and the same expression. Then go to the presentation tab and hopefully the stacked option will be enabled.</P></BODY></HTML> Thu, 16 Dec 2010 18:25:49 GMT https://community.qlik.com/t5/QlikView/How-to-switch-the-dimensions-in-QlikView/m-p/294647#M1200402 pover 2010-12-16T18:25:49Z