topic for each ... Export to XLS in QlikView https://community.qlik.com/t5/QlikView/for-each-Export-to-XLS/m-p/219556#M72572 <HTML><HEAD></HEAD><BODY><P>I have a straight table object I can succesfully export to excel which meets most of my requirements, however the users frequently Filter this object to branch level, export to excel filter to next Branch Export etc.</P><P>How do I Automate this in a for each loop creating a Different Workbook for each Branch</P><P>ColinR</P><P></P><P></P></BODY></HTML> Thu, 21 Jan 2010 17:12:38 GMT 2010-01-21T17:12:38Z for each ... Export to XLS https://community.qlik.com/t5/QlikView/for-each-Export-to-XLS/m-p/219556#M72572 <HTML><HEAD></HEAD><BODY><P>I have a straight table object I can succesfully export to excel which meets most of my requirements, however the users frequently Filter this object to branch level, export to excel filter to next Branch Export etc.</P><P>How do I Automate this in a for each loop creating a Different Workbook for each Branch</P><P>ColinR</P><P></P><P></P></BODY></HTML> Thu, 21 Jan 2010 17:12:38 GMT https://community.qlik.com/t5/QlikView/for-each-Export-to-XLS/m-p/219556#M72572 2010-01-21T17:12:38Z for each ... Export to XLS https://community.qlik.com/t5/QlikView/for-each-Export-to-XLS/m-p/219557#M72573 <HTML><HEAD></HEAD><BODY><P>Hi Colin, here is an example of a macro that iterates through a column generating different xls files based on each selection.</P><P>Hope this helps.</P><P>Regards.</P></BODY></HTML> Thu, 21 Jan 2010 17:27:44 GMT https://community.qlik.com/t5/QlikView/for-each-Export-to-XLS/m-p/219557#M72573 2010-01-21T17:27:44Z