topic Re: Re: Export To Excel SHEETS in QlikView https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611883#M225787 <HTML><HEAD></HEAD><BODY><P>Attached a simple doc with the export in excel, using the macro in the doc</P></BODY></HTML> Thu, 24 Apr 2014 07:11:55 GMT bbi_mba_76 2014-04-24T07:11:55Z Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611879#M225783 <HTML><HEAD></HEAD><BODY><P>Hello Everybody</P><P>That is my first post on the forum. I read a lot of other post about this topic but i did not find the expected information.</P><P>I want to export my active selection to excel. I mean, i have a table (country) and i want to export all the voices (italy,france german ...) in different sheets in excel,and the sheets have to have the name of the country</P><P>Does someone help me?</P><P>thanks in advance</P></BODY></HTML> Wed, 23 Apr 2014 15:24:09 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611879#M225783 2014-04-23T15:24:09Z Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611880#M225784 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> something like this?</P><P><A href="https://community.qlik.com/thread/83200">common Macro to export excel for 6 different objects</A></P></BODY></HTML> Wed, 23 Apr 2014 15:45:58 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611880#M225784 bbi_mba_76 2014-04-23T15:45:58Z Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611881#M225785 <HTML><HEAD></HEAD><BODY><P>hi! not exactly.</P><P></P><P>i need to export from a table, all its fields.</P><P>so, i have an excel file with 3 sheets:</P><P>sheet 1 for italy</P><P>sheet 2 for france</P><P>sheet 3 for german</P><P>sheet n for ....</P><P>italy, german and france are in the same tab. In your link, u export different object in different sheets</P><P>I should export the fields that are in the same tab</P></BODY></HTML> Wed, 23 Apr 2014 16:41:29 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611881#M225785 2014-04-23T16:41:29Z Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611882#M225786 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> it is quite similar: you have to loop for each value of the country fields and then export the same objects in a new sheet. Maybe you could also see this docs</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3481" title="http://community.qlik.com/docs/DOC-3481">http://community.qlik.com/docs/DOC-3481</A></P><P><A href="https://community.qlik.com/docs/DOC-4841">Loop Charts and Field Values - Excel Export Macro</A></P></BODY></HTML> Thu, 24 Apr 2014 06:54:10 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611882#M225786 bbi_mba_76 2014-04-24T06:54:10Z Re: Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611883#M225787 <HTML><HEAD></HEAD><BODY><P>Attached a simple doc with the export in excel, using the macro in the doc</P></BODY></HTML> Thu, 24 Apr 2014 07:11:55 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611883#M225787 bbi_mba_76 2014-04-24T07:11:55Z Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611884#M225788 <HTML><HEAD></HEAD><BODY><P>Ciao Michele.</P><P>Sono riuscito ad esportare correttamente quello che mi serviva.</P><P>ora sono interessato a fare un'altra operazione.</P><P></P><P>Ho un campo che indica tutte le regioni.</P><P>Ho un campo che indica tutti i paesi delle rispettive regioni.</P><P>Mi servirebbe un'esportazione che mi creerebbe 1 file excel per ogni regione, e all'interno di questo file, tutti i paesi della regione.</P><P></P><P>Quindi in totale dovrei avere 20 file excel. Puoi aiutarmi?</P></BODY></HTML> Mon, 28 Apr 2014 07:12:12 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611884#M225788 2014-04-28T07:12:12Z Re: Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611885#M225789 <HTML><HEAD></HEAD><BODY><P>Ciao,</P><P>ho fatto un paio di modifiche ma ho usato la stessa sub.</P><P>In pratica ho aggiunto una sub che fa un loop sul campo country e invoca la precedente.</P><P></P><P>Ciao</P></BODY></HTML> Mon, 28 Apr 2014 08:00:22 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611885#M225789 bbi_mba_76 2014-04-28T08:00:22Z Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611886#M225790 <HTML><HEAD></HEAD><BODY><P>grazie mille per la risposta.</P><P>Quando apro il tuo file qvw, e faccio partire l'esportazione, non succede nulla.</P><P>Si apre solo il file excel, ma non avviene alcuna esportazione.</P><P></P><P>(Nella pagina modifica modulo, รจ selezionata la voce "consenti l'accesso al sistema")</P></BODY></HTML> Mon, 28 Apr 2014 08:36:11 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611886#M225790 2014-04-28T08:36:11Z Re: Export To Excel SHEETS https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611887#M225791 <HTML><HEAD></HEAD><BODY><P>a me crea un file con il foglio CH01-London</P><P>comunque ho dimenticato di mettere una clear all alla fine della sub loopXls</P><P></P><P>&nbsp;&nbsp;&nbsp; ActiveDocument.Fields("Country").Clear</P><P></P><P>eventualmente prova a riprendere la tua versione e aggiungere la sub loopXls</P></BODY></HTML> Mon, 28 Apr 2014 08:44:28 GMT https://community.qlik.com/t5/QlikView/Export-To-Excel-SHEETS/m-p/611887#M225791 bbi_mba_76 2014-04-28T08:44:28Z