topic Re: Table with X and Y dimmensions in QlikView https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358832#M416710 <HTML><HEAD></HEAD><BODY><P>Better you provide few lines of sample data to work.</P><P></P><P>You can use Valuelist function to get the Currency Column</P></BODY></HTML> Fri, 07 Apr 2017 09:52:46 GMT MK_QSL 2017-04-07T09:52:46Z Table with X and Y dimmensions https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358829#M416707 <HTML><HEAD></HEAD><BODY><P>Hey guys , can you please tell me if there is a table where I can have two dimmensions. One as X axis and the other as Y.</P><P>What I`m trying to do is something like in this table</P><TABLE border="1" class="jiveBorder" height="110" style="border: 1px solid #000000; width: 259px; height: 112px;" width="272"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>CURRENCY</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TABLE1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TABLE2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TABLE3</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">EUR</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">USD</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">9</TD></TR></TBODY></TABLE><P></P><P>So for the first dimmension is ID which will be treated as X axis , and The rest of Headers will be treated as Y axes. Can I do that in qlikview?</P><P>Thank you,</P><P>Razvan</P></BODY></HTML> Fri, 07 Apr 2017 08:45:29 GMT https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358829#M416707 razvan_brais 2017-04-07T08:45:29Z Re: Table with X and Y dimmensions https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358830#M416708 <HTML><HEAD></HEAD><BODY><P>Use Pivot Table</P><P>or </P><P>Use Straight table with more than one Expression</P></BODY></HTML> Fri, 07 Apr 2017 08:49:20 GMT https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358830#M416708 MK_QSL 2017-04-07T08:49:20Z Re: Table with X and Y dimmensions https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358831#M416709 <HTML><HEAD></HEAD><BODY><P>Ok , but the problem here is that EUR and USD are columns from table1 , table2 , and table3. I don`t have a column named currency in which I have EUR and USD values.</P></BODY></HTML> Fri, 07 Apr 2017 09:26:22 GMT https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358831#M416709 razvan_brais 2017-04-07T09:26:22Z Re: Table with X and Y dimmensions https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358832#M416710 <HTML><HEAD></HEAD><BODY><P>Better you provide few lines of sample data to work.</P><P></P><P>You can use Valuelist function to get the Currency Column</P></BODY></HTML> Fri, 07 Apr 2017 09:52:46 GMT https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358832#M416710 MK_QSL 2017-04-07T09:52:46Z Re: Table with X and Y dimmensions https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358833#M416711 <HTML><HEAD></HEAD><BODY><P>Thank you. I used Syntetic dimensions and it worked.</P></BODY></HTML> Fri, 07 Apr 2017 13:07:25 GMT https://community.qlik.com/t5/QlikView/Table-with-X-and-Y-dimmensions/m-p/1358833#M416711 razvan_brais 2017-04-07T13:07:25Z