topic Using 2 dimensions on a graph with 2 expressions in QlikView https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394822#M147250 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to know if it is possible to make a graph with 2 lines on it and then use dimensions to split the lines out. So I have 2 tables something like this</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item Number</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ASDA</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Tesco</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price Date</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>10</TD><TD>12</TD><TD>Jun 2012</TD></TR><TR><TD>2</TD><TD>15</TD><TD>18</TD><TD>Jun 2012</TD></TR><TR><TD>3</TD><TD>20</TD><TD>24</TD><TD>Jun 2012</TD></TR><TR><TD>4</TD><TD>25</TD><TD>30</TD><TD>Jun 2012</TD></TR><TR><TD>1</TD><TD>11</TD><TD>9</TD><TD>Aug 2012</TD></TR><TR><TD>2</TD><TD>16</TD><TD>15</TD><TD>Aug 2012</TD></TR><TR><TD>3</TD><TD>25</TD><TD>21</TD><TD>Aug 2012</TD></TR><TR><TD>4</TD><TD>30</TD><TD>27</TD><TD>Aug 2012</TD></TR></TBODY></TABLE><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item Number</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Size</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Colour</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>Small</TD><TD>Green</TD></TR><TR><TD>2</TD><TD>Large</TD><TD>Green</TD></TR><TR><TD>3</TD><TD>Small</TD><TD>Blue</TD></TR><TR><TD>4</TD><TD>Large</TD><TD>Blue</TD></TR></TBODY></TABLE><P></P><P>So my graph has 2 lines on it average ASDA price and average Tesco Price with the dimension price date to see how prices change through time. I then want to be able to easily split these lines up so I can see how prices of small and large change at tesco and asda so there would be 4 lines on the graph and then be able to click and see how different colour prices change through time too. On graphs with just one line I have been able to do this with a cyclic second dimension so I can just change that dimension and the lines are grouped by whatever the second dimension is but I have found when I have 2 expressions Qlikview will not do this.</P><P></P><P>Hopefully that made some sense. Is there another way?</P><P></P><P>Thanks a lot</P><P>Richard</P></BODY></HTML> Fri, 30 Nov 2012 15:15:27 GMT 2012-11-30T15:15:27Z Using 2 dimensions on a graph with 2 expressions https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394822#M147250 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to know if it is possible to make a graph with 2 lines on it and then use dimensions to split the lines out. So I have 2 tables something like this</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item Number</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ASDA</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Tesco</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price Date</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>10</TD><TD>12</TD><TD>Jun 2012</TD></TR><TR><TD>2</TD><TD>15</TD><TD>18</TD><TD>Jun 2012</TD></TR><TR><TD>3</TD><TD>20</TD><TD>24</TD><TD>Jun 2012</TD></TR><TR><TD>4</TD><TD>25</TD><TD>30</TD><TD>Jun 2012</TD></TR><TR><TD>1</TD><TD>11</TD><TD>9</TD><TD>Aug 2012</TD></TR><TR><TD>2</TD><TD>16</TD><TD>15</TD><TD>Aug 2012</TD></TR><TR><TD>3</TD><TD>25</TD><TD>21</TD><TD>Aug 2012</TD></TR><TR><TD>4</TD><TD>30</TD><TD>27</TD><TD>Aug 2012</TD></TR></TBODY></TABLE><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item Number</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Size</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Colour</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>Small</TD><TD>Green</TD></TR><TR><TD>2</TD><TD>Large</TD><TD>Green</TD></TR><TR><TD>3</TD><TD>Small</TD><TD>Blue</TD></TR><TR><TD>4</TD><TD>Large</TD><TD>Blue</TD></TR></TBODY></TABLE><P></P><P>So my graph has 2 lines on it average ASDA price and average Tesco Price with the dimension price date to see how prices change through time. I then want to be able to easily split these lines up so I can see how prices of small and large change at tesco and asda so there would be 4 lines on the graph and then be able to click and see how different colour prices change through time too. On graphs with just one line I have been able to do this with a cyclic second dimension so I can just change that dimension and the lines are grouped by whatever the second dimension is but I have found when I have 2 expressions Qlikview will not do this.</P><P></P><P>Hopefully that made some sense. Is there another way?</P><P></P><P>Thanks a lot</P><P>Richard</P></BODY></HTML> Fri, 30 Nov 2012 15:15:27 GMT https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394822#M147250 2012-11-30T15:15:27Z Re: Using 2 dimensions on a graph with 2 expressions https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394823#M147251 <HTML><HEAD></HEAD><BODY><P>could you send sample file?</P></BODY></HTML> Sat, 01 Dec 2012 19:10:25 GMT https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394823#M147251 2012-12-01T19:10:25Z Re: Using 2 dimensions on a graph with 2 expressions https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394824#M147252 <HTML><HEAD></HEAD><BODY><P>This should show the problem. The first graph has average tesco and average asda prices with a second cyclic dimension which does nothing whereas the second graph has just average asda price and a second cyclic dimension which allows you to rotate through the different field details and the average asda price is split up. Ideally I would have one graph with average asda and average tesco prices which are then split up by size or colour and I can just click a button to cycle through the dimensions. The actual file I'm working on has a lot more dimensions, this is just a simplified example.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 03 Dec 2012 10:17:56 GMT https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394824#M147252 2012-12-03T10:17:56Z Re: Using 2 dimensions on a graph with 2 expressions https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394825#M147253 <HTML><HEAD></HEAD><BODY><P>i think it is imposible to do it </P><P></P><P></P><P>you can still do it by variable (and conditional show/hiden expressions) but with more dimension it would be dificult to provide</P></BODY></HTML> Mon, 03 Dec 2012 11:22:25 GMT https://community.qlik.com/t5/QlikView/Using-2-dimensions-on-a-graph-with-2-expressions/m-p/394825#M147253 2012-12-03T11:22:25Z