topic Crossing same dimension -Vector in QlikView https://community.qlik.com/t5/QlikView/Crossing-same-dimension-Vector/m-p/675670#M245304 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I'm having some trouble trying to cross a table. I have a dimension called year where for each year I'm summing some values. Now I need to compare among these years a percentual growth. My idea is to make a cross table, like the following:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Ano</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2010</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2011</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2012</TH></TR><TR><TD style="padding: 2px; text-align: center;">2010</TD><TD style="padding: 2px;">0%</TD><TD style="padding: 2px;">-5%</TD><TD style="padding: 2px;">-2%</TD></TR><TR><TD style="padding: 2px; text-align: center;">2011</TD><TD style="padding: 2px;">10%</TD><TD style="padding: 2px;">0%</TD><TD style="padding: 2px;">12%</TD></TR><TR><TD style="padding: 2px; text-align: center;">2012</TD><TD style="padding: 2px;">15%</TD><TD style="padding: 2px;">-15%</TD><TD style="padding: 2px;">0%</TD></TR></TBODY></TABLE><P></P><P>I've tried duplicating the year dimension by creating year2 and crossing these dimensions, but no success.</P><P></P><P>If anybody could give me a clue of how I can solve this, I'd be really glad.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 23 Sep 2014 17:23:49 GMT 2014-09-23T17:23:49Z Crossing same dimension -Vector https://community.qlik.com/t5/QlikView/Crossing-same-dimension-Vector/m-p/675670#M245304 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I'm having some trouble trying to cross a table. I have a dimension called year where for each year I'm summing some values. Now I need to compare among these years a percentual growth. My idea is to make a cross table, like the following:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Ano</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2010</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2011</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">2012</TH></TR><TR><TD style="padding: 2px; text-align: center;">2010</TD><TD style="padding: 2px;">0%</TD><TD style="padding: 2px;">-5%</TD><TD style="padding: 2px;">-2%</TD></TR><TR><TD style="padding: 2px; text-align: center;">2011</TD><TD style="padding: 2px;">10%</TD><TD style="padding: 2px;">0%</TD><TD style="padding: 2px;">12%</TD></TR><TR><TD style="padding: 2px; text-align: center;">2012</TD><TD style="padding: 2px;">15%</TD><TD style="padding: 2px;">-15%</TD><TD style="padding: 2px;">0%</TD></TR></TBODY></TABLE><P></P><P>I've tried duplicating the year dimension by creating year2 and crossing these dimensions, but no success.</P><P></P><P>If anybody could give me a clue of how I can solve this, I'd be really glad.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 23 Sep 2014 17:23:49 GMT https://community.qlik.com/t5/QlikView/Crossing-same-dimension-Vector/m-p/675670#M245304 2014-09-23T17:23:49Z