topic problem loading data from xls in QlikView https://community.qlik.com/t5/QlikView/problem-loading-data-from-xls/m-p/188187#M51549 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I guess you mean how to load what in excel are rows as fields (columns) in your script.</P><P>I'd recommend you to take a look at <A href="http://community.qlik.com/media/p/130199.aspx" title="Simple Crosstable Sample">this file</A> and use the code in it to load first sales, then profits.</P><P>Hope it helps.</P></BODY></HTML> Tue, 16 Nov 2010 06:53:27 GMT Miguel_Angel_Baeyens 2010-11-16T06:53:27Z problem loading data from xls https://community.qlik.com/t5/QlikView/problem-loading-data-from-xls/m-p/188186#M51548 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>if an excel has the format of content like below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 343pt; border-collapse: collapse;" width="456"><COLGROUP><COL style="width: 76pt; mso-width-source: userset; mso-width-alt: 3232;" width="101" /><COL style="width: 72pt; mso-width-source: userset; mso-width-alt: 3072;" width="96" /><COL style="width: 58pt; mso-width-source: userset; mso-width-alt: 2464;" width="77" /><COL style="width: 72pt; mso-width-source: userset; mso-width-alt: 3072;" width="96" /><COL style="width: 65pt; mso-width-source: userset; mso-width-alt: 2752;" width="86" /></COLGROUP><TBODY><TR height="21" style="height: 15.75pt;"><TD class="xl79" height="40" rowspan="2" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; width: 76pt; border-bottom: black 0.5pt solid; height: 30pt; background-color: transparent;" width="101"><STRONG>product</STRONG></TD><TD class="xl81" colspan="2" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 130pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="173"><STRONG>Jan</STRONG></TD><TD class="xl81" colspan="2" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 137pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="182"><STRONG>Feb</STRONG></TD></TR><TR height="19" style="height: 14.25pt;"><TD class="xl78" height="19" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; height: 14.25pt; background-color: transparent;"><STRONG>sales</STRONG></TD><TD class="xl78" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;"><STRONG>profits</STRONG></TD><TD class="xl78" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;"><STRONG>sales</STRONG></TD><TD class="xl78" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;"><STRONG>profits</STRONG></TD></TR></TBODY></TABLE><BR /><BR /> <P>what is the best solution to load them? thanks in advance!</P></BODY></HTML> Tue, 16 Nov 2010 04:04:16 GMT https://community.qlik.com/t5/QlikView/problem-loading-data-from-xls/m-p/188186#M51548 2010-11-16T04:04:16Z problem loading data from xls https://community.qlik.com/t5/QlikView/problem-loading-data-from-xls/m-p/188187#M51549 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I guess you mean how to load what in excel are rows as fields (columns) in your script.</P><P>I'd recommend you to take a look at <A href="http://community.qlik.com/media/p/130199.aspx" title="Simple Crosstable Sample">this file</A> and use the code in it to load first sales, then profits.</P><P>Hope it helps.</P></BODY></HTML> Tue, 16 Nov 2010 06:53:27 GMT https://community.qlik.com/t5/QlikView/problem-loading-data-from-xls/m-p/188187#M51549 Miguel_Angel_Baeyens 2010-11-16T06:53:27Z