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

[pgrs4219]

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

[maxgro]

for Qlikview desktop in Menù --> User Preferences

unckeck "On BIFF Exports"

[pgrs4219]

Hi Maxgro,

thanks for your reply.am attaching my settings.

[maxgro]

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

[marcus_sommer]

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

- Marcus

[sergio0592]

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

[maxgro]

Marcus already answered, look at the link he posted

[sergio0592]

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.

[marcus_sommer]

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