topic send to excel and split sheets in QlikView https://community.qlik.com/t5/QlikView/send-to-excel-and-split-sheets/m-p/761759#M270918 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">I want to export a qlikview object (table box) to an excel sheet and then split it into multiple sheets based on the first column of the table box. My table would be something like below. I would want to export ID with value 1 in Sheet1, ID-2 in sheet2 etc. </SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Any suggestions? Thanks in advance.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR style="height: 15.0pt;"><TD class="xl63" height="20" style="height: 15.0pt; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">ID<SPAN class="font5"> </SPAN></SPAN></TD><TD class="xl63" style="border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">average<SPAN class="font5"> </SPAN></SPAN></TD><TD class="xl63" style="border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">count<SPAN class="font5"> </SPAN></SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">900</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">100</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">901</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">101</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">902</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">102</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">903</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">103</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">904</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">104</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">905</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">105</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">906</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">106</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">907</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">107</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">908</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">108</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">909</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">109</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">910</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">110</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">911</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">111</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 08 Mar 2015 19:02:54 GMT 2015-03-08T19:02:54Z send to excel and split sheets https://community.qlik.com/t5/QlikView/send-to-excel-and-split-sheets/m-p/761759#M270918 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">I want to export a qlikview object (table box) to an excel sheet and then split it into multiple sheets based on the first column of the table box. My table would be something like below. I would want to export ID with value 1 in Sheet1, ID-2 in sheet2 etc. </SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Any suggestions? Thanks in advance.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR style="height: 15.0pt;"><TD class="xl63" height="20" style="height: 15.0pt; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">ID<SPAN class="font5"> </SPAN></SPAN></TD><TD class="xl63" style="border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">average<SPAN class="font5"> </SPAN></SPAN></TD><TD class="xl63" style="border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">count<SPAN class="font5"> </SPAN></SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">900</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">100</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">901</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">101</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">902</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">102</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">1</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">903</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">103</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">904</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">104</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">905</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">105</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">906</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">106</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">2</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">907</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">107</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">908</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">108</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">909</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">109</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">910</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">110</SPAN></TD></TR><TR style="height: 15.0pt;"><TD class="xl64" height="20" style="height: 15.0pt; border-top: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">3</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">911</SPAN></TD><TD class="xl64" style="border-top: none; border-left: none; width: 48pt;" width="64"><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">111</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 08 Mar 2015 19:02:54 GMT https://community.qlik.com/t5/QlikView/send-to-excel-and-split-sheets/m-p/761759#M270918 2015-03-08T19:02:54Z Re: send to excel and split sheets https://community.qlik.com/t5/QlikView/send-to-excel-and-split-sheets/m-p/761760#M270919 <HTML><HEAD></HEAD><BODY><P>Perhaps this document helps: <A href="https://community.qlik.com/docs/DOC-4841">Loop Charts and Field Values - Excel Export Macro</A></P></BODY></HTML> Mon, 09 Mar 2015 14:57:48 GMT https://community.qlik.com/t5/QlikView/send-to-excel-and-split-sheets/m-p/761760#M270919 Gysbert_Wassenaar 2015-03-09T14:57:48Z