topic Re: How to work effectively loading data from Crosstabs? in QlikView https://community.qlik.com/t5/QlikView/How-to-work-effectively-loading-data-from-Crosstabs/m-p/758382#M664190 <HTML><HEAD></HEAD><BODY><P>Maybe you can use this: <A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Fri, 23 Jan 2015 14:54:45 GMT Gysbert_Wassenaar 2015-01-23T14:54:45Z How to work effectively loading data from Crosstabs? https://community.qlik.com/t5/QlikView/How-to-work-effectively-loading-data-from-Crosstabs/m-p/758381#M664189 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P>I am new to QV and I am struggling with crosstabs when loading data into Qlikview. Experts please guide me on how to work effectively with these crosstabs.</P><P>For example this is how my data looks like</P><TABLE border="0" cellpadding="0" cellspacing="0" height="144" style="width: 770px; height: 90px;" width="768"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 48pt;" width="64"></TD><TD style="width: 65pt;" width="87"></TD><TD style="width: 65pt;" width="87"></TD><TD class="xl63" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Oct-14</SPAN></TD><TD class="xl64" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Nov-14</SPAN></TD><TD class="xl65" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Dec-14</SPAN></TD><TD class="xl66" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Jan-15</SPAN></TD><TD class="xl67" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Feb-15</SPAN></TD><TD class="xl68" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Mar-15</SPAN></TD><TD class="xl69" colspan="2" style="width: 96pt;" width="128"><SPAN style="font-size: 8pt;">Apr-15</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl70" height="20" style="height: 15.0pt;"><SPAN style="font-size: 8pt;">products</SPAN></TD><TD class="xl70"><SPAN style="font-size: 8pt;">Product Desc</SPAN></TD><TD class="xl70"><SPAN style="font-size: 8pt;">Sold to Cust</SPAN></TD><TD class="xl71"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl71"><SPAN style="font-size: 8pt;">Qty</SPAN></TD><TD class="xl72"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl72"><SPAN style="font-size: 8pt;">Qty</SPAN></TD><TD class="xl73"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl73"><SPAN style="font-size: 8pt;">Qty</SPAN></TD><TD class="xl74"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl74"><SPAN style="font-size: 8pt;">Qty</SPAN></TD><TD class="xl75"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl75"><SPAN style="font-size: 8pt;">Qty</SPAN></TD><TD class="xl76"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl76"><SPAN style="font-size: 8pt;">Qty</SPAN></TD><TD class="xl77"><SPAN style="font-size: 8pt;">Gross $</SPAN></TD><TD class="xl77"><SPAN style="font-size: 8pt;">Qty</SPAN></TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;"><SPAN style="font-size: 8pt;">gear1</SPAN></TD><TD><SPAN style="font-size: 8pt;">Jacket blue</SPAN></TD><TD><SPAN style="font-size: 8pt;">Walmart</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">10215</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">10086</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6884</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14462</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14723</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6722</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">9773</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">10214</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">9885</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14516</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">8659</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">7100</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">8172</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6833</SPAN></TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;"><SPAN style="font-size: 8pt;">gear2</SPAN></TD><TD><SPAN style="font-size: 8pt;">Jacket Red</SPAN></TD><TD><SPAN style="font-size: 8pt;">Target</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">12941</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">9727</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">13301</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">7155</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">13887</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">13589</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6292</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14074</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14025</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6376</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">10083</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">7740</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">9466</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">9412</SPAN></TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;"><SPAN style="font-size: 8pt;">gear3</SPAN></TD><TD><SPAN style="font-size: 8pt;">Jacket Black</SPAN></TD><TD><SPAN style="font-size: 8pt;">Bay</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14229</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">11919</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">9970</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6011</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">10060</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">8979</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">12842</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14102</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">8814</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6640</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">14918</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">8440</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">6241</SPAN></TD><TD align="right"><SPAN style="font-size: 8pt;">7059</SPAN></TD></TR></TBODY></TABLE><P></P><P>How do I script this, I tried Crosstab option but periods and 2 measures making it difficult.</P><P>Thanks</P><P>Rashid</P></BODY></HTML> Fri, 23 Jan 2015 14:47:17 GMT https://community.qlik.com/t5/QlikView/How-to-work-effectively-loading-data-from-Crosstabs/m-p/758381#M664189 rmuhammad 2015-01-23T14:47:17Z Re: How to work effectively loading data from Crosstabs? https://community.qlik.com/t5/QlikView/How-to-work-effectively-loading-data-from-Crosstabs/m-p/758382#M664190 <HTML><HEAD></HEAD><BODY><P>Maybe you can use this: <A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Fri, 23 Jan 2015 14:54:45 GMT https://community.qlik.com/t5/QlikView/How-to-work-effectively-loading-data-from-Crosstabs/m-p/758382#M664190 Gysbert_Wassenaar 2015-01-23T14:54:45Z