topic Re: How to avoid current selections box while doing export to excel? in QlikView

How to avoid current selections box while doing export to excel?

pgrs4219 — Mon, 26 Jan 2026 18:19:17 GMT

Hi Community,

I have a requirement that when i am exporting the pivot/Straight table its should only export that particular object, but unfortunately in my current application its exporting object along with the current selections as well. please help me how to avoid this.

Thanks

Re: How to avoid current selections box while doing export to excel?

maxgro — Mon, 10 Oct 2016 19:16:25 GMT

for Qlikview desktop in Menù --> User Preferences

unckeck "On BIFF Exports"

Re: How to avoid current selections box while doing export to excel?

pgrs4219 — Mon, 10 Oct 2016 20:11:06 GMT

Hi Maxgro,

thanks for your reply.am attaching my settings.

Re: How to avoid current selections box while doing export to excel?

maxgro — Mon, 10 Oct 2016 20:33:48 GMT

In my Qlik 11.20 SR 15 it works, when I uncheck "On BIFF Exports" current selection isn't exported in excel

Re: How to avoid current selections box while doing export to excel?

marcus_sommer — Tue, 11 Oct 2016 07:30:55 GMT

Take a look here: Export Current Selections to Excel by Default

- Marcus

Re: How to avoid current selections box while doing export to excel?

sergio0592 — Tue, 11 Oct 2016 12:52:00 GMT

And how to access to User Préférences Check/unckeck "BIFF Exports" for users which are connected with Access Point?

Re: How to avoid current selections box while doing export to excel?

maxgro — Tue, 11 Oct 2016 15:10:07 GMT

Marcus already answered, look at the link he posted

Re: How to avoid current selections box while doing export to excel?

sergio0592 — Tue, 11 Oct 2016 19:34:51 GMT

I have already read Marcus's answer but sorry, my need was only in my mind....

I am looking for get current selections in Excel exports but only for one application (or only for users which access to this app), via Acess Point of course.

Re: How to avoid current selections box while doing export to excel?

marcus_sommer — Wed, 12 Oct 2016 05:32:02 GMT

Unfortunately is this a global option - either on or off. The only option would be to include the selection state within the object itself but because there is no object-title available by exporting to excel it would need to add this as a dimension or expression which certainly don't look very nice ...

- Marcus