topic Re: Current Selections in Export to Excel in QlikView https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293932#M109044 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You want that when you export a data as send to excel on that time you want which fileds are selected so in this case you need to select Getfieldselections(ColumnName) and try to export that one. Or also you need to check the settings in user preference "On BIFF Exports" if it is checked mark it is ok.</P><P></P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Tue, 23 Aug 2011 14:37:53 GMT its_anandrjs 2011-08-23T14:37:53Z Current Selections in Export to Excel https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293930#M109042 <HTML><HEAD></HEAD><BODY><P>When exporting to Excel, is there an option somewhere to show all the current selections? I can't find such an option anywhere!</P></BODY></HTML> Tue, 23 Aug 2011 14:32:50 GMT https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293930#M109042 danielact 2011-08-23T14:32:50Z Current Selections in Export to Excel https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293931#M109043 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>it's actually a User Preference. Press Ctrl + Alt + U, and find the Export tab. At the bottom left, you'll find the selection:</P><P>"On HTML export" is default.</P><P>Also select "On BIFF export" and your good to go!</P><P></P><P>Good luck!</P><P>Rgds</P><P>Jonas</P><P></P><P><A href="http://www.optivasys.se">www.optivasys.se</A></P></BODY></HTML> Tue, 23 Aug 2011 14:35:34 GMT https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293931#M109043 2011-08-23T14:35:34Z Re: Current Selections in Export to Excel https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293932#M109044 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You want that when you export a data as send to excel on that time you want which fileds are selected so in this case you need to select Getfieldselections(ColumnName) and try to export that one. Or also you need to check the settings in user preference "On BIFF Exports" if it is checked mark it is ok.</P><P></P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Tue, 23 Aug 2011 14:37:53 GMT https://community.qlik.com/t5/QlikView/Current-Selections-in-Export-to-Excel/m-p/293932#M109044 its_anandrjs 2011-08-23T14:37:53Z