topic Crosstable from ODBC or OLE DB source in QlikView https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182753#M48256 <HTML><HEAD></HEAD><BODY><P>That helped me a lot! Works like a charm!</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 16 Nov 2011 13:44:34 GMT bengan74 2011-11-16T13:44:34Z Crosstable from ODBC or OLE DB source https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182751#M48254 <HTML><HEAD></HEAD><BODY><P>The crosstable option is not available when loading a table from SQL Server via ODBC or OLE DB.</P><P>Why is this ?</P><P>What would be a workaround ?</P></BODY></HTML> Fri, 25 Mar 2011 20:55:27 GMT https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182751#M48254 2011-03-25T20:55:27Z Crosstable from ODBC or OLE DB source https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182752#M48255 <HTML><HEAD></HEAD><BODY><P>Crosstable is not part of the wizard, but the functionality works exactly the same way. The following prefix goes before your load statement:</P><P>CROSSTABLE ( AttributeName, DataName, &lt;Number of Qualifying Fields&gt; )</P><P>You might have to first load from the database and then reload "Resident" if the preceding load doesn't work for some reason...</P><P></P><P></P></BODY></HTML> Fri, 25 Mar 2011 21:28:33 GMT https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182752#M48255 Oleg_Troyansky 2011-03-25T21:28:33Z Crosstable from ODBC or OLE DB source https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182753#M48256 <HTML><HEAD></HEAD><BODY><P>That helped me a lot! Works like a charm!</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 16 Nov 2011 13:44:34 GMT https://community.qlik.com/t5/QlikView/Crosstable-from-ODBC-or-OLE-DB-source/m-p/182753#M48256 bengan74 2011-11-16T13:44:34Z