Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pgrs4219
New Contributor II

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

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

8 Replies
MVP
MVP

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

for Qlikview desktop in Menù --> User Preferences

unckeck "On BIFF Exports"

1.png

pgrs4219
New Contributor II

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

Hi Maxgro,

thanks for your reply.am attaching my settings.Capture 12.PNG

MVP
MVP

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

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

MVP & Luminary
MVP & Luminary

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

sergio0592
Valued Contributor II

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

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

MVP
MVP

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

Marcus already answered, look at the link he posted

sergio0592
Valued Contributor II

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

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.

MVP & Luminary
MVP & Luminary

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

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