topic Excel Import/Cross table in QlikView https://community.qlik.com/t5/QlikView/Excel-Import-Cross-table/m-p/362480#M1171363 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have about 40 spreadsheets in the following format which I need to import. </P><P>I can write some VBA stuff but id like to do this in QV. I think Ill need some kind of Crosstable notion but Im not sure.</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Description</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Age</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Q1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Staff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Q2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Staff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Q3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales ... ...</STRONG></SPAN></TH></TR><TR><TD>Leeds</TD><TD>2</TD><TD></TD><TD>4554</TD><TD>323</TD><TD></TD><TD>2323</TD><TD>4343</TD><TD></TD><TD>7676</TD></TR><TR><TD>London</TD><TD>3</TD><TD></TD><TD>446</TD><TD>434</TD><TD></TD><TD>5454</TD><TD>2323</TD><TD></TD><TD>7676</TD></TR></TBODY></TABLE><P></P><P></P><P>and I need something like</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Description</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Age</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quarter</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Staff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH></TR><TR><TD><P>Leeds</P></TD><TD>2</TD><TD>1</TD><TD>4554</TD><TD>323</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>Leeds</TD><TD>2</TD><TD>2</TD><TD>2323</TD><TD>4343</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>Leeds</TD><TD>2</TD><TD>3</TD><TD>7676</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>London</TD><TD>3</TD><TD>1</TD><TD>446</TD><TD>434</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>London</TD><TD>3</TD><TD>2</TD><TD>5454</TD><TD>2323</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>The Q1/Q2 columns in my data were just sum(Sales+Staff) and so I dont need it.</P><P></P><P>I've tried various rotations and things and not got too far. Any ideas? Ideally something step by step <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Attached is a skeleton of my data</P></BODY></HTML> Thu, 21 Jun 2012 11:32:08 GMT 2012-06-21T11:32:08Z Excel Import/Cross table https://community.qlik.com/t5/QlikView/Excel-Import-Cross-table/m-p/362480#M1171363 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have about 40 spreadsheets in the following format which I need to import. </P><P>I can write some VBA stuff but id like to do this in QV. I think Ill need some kind of Crosstable notion but Im not sure.</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Description</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Age</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Q1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Staff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Q2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Staff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Q3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales ... ...</STRONG></SPAN></TH></TR><TR><TD>Leeds</TD><TD>2</TD><TD></TD><TD>4554</TD><TD>323</TD><TD></TD><TD>2323</TD><TD>4343</TD><TD></TD><TD>7676</TD></TR><TR><TD>London</TD><TD>3</TD><TD></TD><TD>446</TD><TD>434</TD><TD></TD><TD>5454</TD><TD>2323</TD><TD></TD><TD>7676</TD></TR></TBODY></TABLE><P></P><P></P><P>and I need something like</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Description</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Age</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quarter</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Staff</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH></TR><TR><TD><P>Leeds</P></TD><TD>2</TD><TD>1</TD><TD>4554</TD><TD>323</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>Leeds</TD><TD>2</TD><TD>2</TD><TD>2323</TD><TD>4343</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>Leeds</TD><TD>2</TD><TD>3</TD><TD>7676</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>London</TD><TD>3</TD><TD>1</TD><TD>446</TD><TD>434</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>London</TD><TD>3</TD><TD>2</TD><TD>5454</TD><TD>2323</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>The Q1/Q2 columns in my data were just sum(Sales+Staff) and so I dont need it.</P><P></P><P>I've tried various rotations and things and not got too far. Any ideas? Ideally something step by step <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Attached is a skeleton of my data</P></BODY></HTML> Thu, 21 Jun 2012 11:32:08 GMT https://community.qlik.com/t5/QlikView/Excel-Import-Cross-table/m-p/362480#M1171363 2012-06-21T11:32:08Z