topic Re: AJAX Excel Export Ideas... in QlikView https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655882#M239497 <HTML><HEAD></HEAD><BODY><P>See the attached file.</P><P></P><P>It uses two objects, where the underlaying object has additional expressions for username, documentname and time, only on the first row.</P><P><SPAN style="font-size: 10pt;">The overlaying object has no title, so the title (and export button) is actually the object underneath (which on export will include the additional columns you specify).</SPAN></P></BODY></HTML> Fri, 03 Oct 2014 13:22:52 GMT Anonymous 2014-10-03T13:22:52Z AJAX Excel Export Ideas... https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655880#M239495 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P>Based on the forums, this is a VERY popular subject (Qlik - some functionality missing?!).</P><P></P><P>My clent has moved, as often recommended, to the AJAX client but they have a large group of users that insist on having some additional meta-data when exporting objects to Excel. Namely User, Application Name, Object Name and date of export.</P><P></P><P>Does anyone have any half-decent ideas about how to do this? Ideally it needs to be flexible and (fairly) low maintenance!</P><P></P><P>My only idea so far is:</P><P>- Export to CSV (using 'export' action) then ask Excel&nbsp; to do some processing to generate the object etc. This doesn't sound easy nor maintainable to me.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 03 Oct 2014 12:35:50 GMT https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655880#M239495 juleshartley 2014-10-03T12:35:50Z Re: AJAX Excel Export Ideas... https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655881#M239496 <HTML><HEAD></HEAD><BODY><P>In what format do you (your customer) want this metadata when exporting?</P></BODY></HTML> Fri, 03 Oct 2014 13:02:49 GMT https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655881#M239496 Anonymous 2014-10-03T13:02:49Z Re: AJAX Excel Export Ideas... https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655882#M239497 <HTML><HEAD></HEAD><BODY><P>See the attached file.</P><P></P><P>It uses two objects, where the underlaying object has additional expressions for username, documentname and time, only on the first row.</P><P><SPAN style="font-size: 10pt;">The overlaying object has no title, so the title (and export button) is actually the object underneath (which on export will include the additional columns you specify).</SPAN></P></BODY></HTML> Fri, 03 Oct 2014 13:22:52 GMT https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655882#M239497 Anonymous 2014-10-03T13:22:52Z Re: AJAX Excel Export Ideas... https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655883#M239498 <HTML><HEAD></HEAD><BODY><P>Ideally in excel, with the metadata as showing below the object data (like the current selections does)</P></BODY></HTML> Fri, 03 Oct 2014 14:05:07 GMT https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655883#M239498 juleshartley 2014-10-03T14:05:07Z Re: AJAX Excel Export Ideas... https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655884#M239499 <HTML><HEAD></HEAD><BODY><P>Nice work around! Thanks.</P></BODY></HTML> Fri, 03 Oct 2014 14:34:33 GMT https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655884#M239499 juleshartley 2014-10-03T14:34:33Z Re: AJAX Excel Export Ideas... https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655885#M239500 <HTML><HEAD></HEAD><BODY><P>No problem,&nbsp; I'm glad you liked it! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 04 Oct 2014 02:05:33 GMT https://community.qlik.com/t5/QlikView/AJAX-Excel-Export-Ideas/m-p/655885#M239500 Anonymous 2014-10-04T02:05:33Z