topic Re: Complicated crosstable in QlikView https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652647#M675538 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert you are really helpful,</P><P></P><P>Is there any way to have the data table exactly as the straight table is instead of making the dimension horizontal?</P><P>It would be really easier for calculations. </P></BODY></HTML> Wed, 25 Jun 2014 14:01:23 GMT 2014-06-25T14:01:23Z Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652645#M675536 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have a slightly hard cross table transformation that I need to do.</P><P>Lets say I have the below table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="448"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">FieldA.1</TD><TD width="64">FieldA.2</TD><TD width="64">FieldA.3</TD><TD width="64">FieldB.1</TD><TD width="64">FieldB.2</TD><TD width="64">FieldC.1</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD>b</TD><TD>c</TD><TD>r</TD><TD>t</TD><TD>y</TD></TR></TBODY></TABLE><P></P><P>And I want to transpose that to:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">Case</TD><TD width="64">Field1</TD><TD width="64">Field2</TD><TD width="64">Field3</TD></TR><TR><TD align="right" height="20">1</TD><TD>A</TD><TD>a</TD><TD>b</TD><TD>c</TD></TR><TR><TD align="right" height="20">1</TD><TD>B</TD><TD>r</TD><TD>t</TD><TD></TD></TR><TR><TD align="right" height="20">1</TD><TD>C</TD><TD>y</TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>Is that possible in any kind of way?</P><P>Take into account that the number of Columns in each case are not fixed so I can have case 1 with 10 fields and case B with 1.</P><P></P><P>Any help appreciated.</P></BODY></HTML> Wed, 25 Jun 2014 13:25:42 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652645#M675536 2014-06-25T13:25:42Z Re: Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652646#M675537 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Wed, 25 Jun 2014 13:36:15 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652646#M675537 Gysbert_Wassenaar 2014-06-25T13:36:15Z Re: Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652647#M675538 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert you are really helpful,</P><P></P><P>Is there any way to have the data table exactly as the straight table is instead of making the dimension horizontal?</P><P>It would be really easier for calculations. </P></BODY></HTML> Wed, 25 Jun 2014 14:01:23 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652647#M675538 2014-06-25T14:01:23Z Re: Complicated crosstable https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652648#M675539 <HTML><HEAD></HEAD><BODY><P>Yes, you can add the keyword GENERIC before the word LOAD in the second load statement in the script.</P></BODY></HTML> Wed, 25 Jun 2014 14:06:52 GMT https://community.qlik.com/t5/QlikView/Complicated-crosstable/m-p/652648#M675539 Gysbert_Wassenaar 2014-06-25T14:06:52Z