topic Re: Export into excel Problem in QlikView

Export into excel Problem

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

While Exporting the pivot table data into excel we will get only data only.

but my client want to export the pivot table data including current selections.

because client exporting multiple selection and exports.

I tried User preference option Export to Excel BIFF selection.this is working fine in Local files.

But I want to do same in Access point. I could not find any solution for this.

So please guide some one.

Thanks

Surender

Re: Export into excel Problem

jonathandienst — Thu, 25 Jun 2015 07:44:59 GMT

The option is a USER option, so it only applies to the user who set it. And I suspect that it only applies to opening the document in the desktop client, which he can do if he has a named CAL (Open In server option).

Re: Export into excel Problem

Thu, 25 Jun 2015 08:00:48 GMT

Thanks for your reply..

Where can i get the User option.

My client want to export to Excel from Qlikview Accesspoint not from Open in server.

Please help me where can i do the settings

Thanks

Re: Export into excel Problem

settu_periasamy — Thu, 25 Jun 2015 08:18:23 GMT

Hi Surender,

Did you try this in your file?

Help -> About Qlikview -> then set SelectionStampInBIFFExport as 1

if not working , May be you can ask your client to set the user preference in the access point like the below screen shot.

This link also helpful for you

http://www.qlikblog.at/583/qliktip-1-transferring-current-selections-excelexport-translated/

Re: Export into excel Problem

Fri, 26 Jun 2015 05:27:03 GMT

Hi,

Thanks for your reply.

I tried the same settings.but still am not able to download the current selections.

I Tried in Server settings.Config

C:\Documents and Settings\All Users\Application Data\QlikTech\QlikViewServer\

Within the section [Settings 7] add the following line (doesn’t matter where):

SelectionStampInBIFFExport=1

This setting also i have done. Still am not able to download the current selections.

Please help .

Thanks

Re: Export into excel Problem

settu_periasamy — Fri, 26 Jun 2015 05:31:08 GMT

did you tried the access point user preference settings? not in server..

mentioned in 2nd picture

Re: Export into excel Problem

jagan — Fri, 26 Jun 2015 06:19:15 GMT

HI,

I think you need to restart the services then only this changes reflects.

Also you can try like below

In the access point, try like this

Menu-> User Preferences-> Export -> Select On BIFF Exports option

Note: This should be done individually in all the user's PC.

Regards,

jagan.

Re: Export into excel Problem

Fri, 26 Jun 2015 06:26:40 GMT

Hi,

I Could not find the second snapshot in Access point.

In Qlikview development we have the user preferences.

but Accesspoint i could not seen any menu option

Please find the below snapshot from Accesspoint

thanks

Re: Export into excel Problem

jagan — Fri, 26 Jun 2015 06:32:00 GMT

You can try this option in IE Plug in mode and not in Ajax mode. Did you tried to restart the services? If you restart then this is not required.

Regards,

jagan.

Re: Export into excel Problem

Fri, 26 Jun 2015 06:42:15 GMT

Hi Jagan,

Yes I started services.but how to change the Ajax mode to IE.

I tried in Server

System> Web services>Ajax

I changed IE instead of Ajax

Still not working.

Thanks

Re: Export into excel Problem

jagan — Fri, 26 Jun 2015 06:48:28 GMT

Hi,

You need to download and install Qlikview IE Plugin Software and access the Dashboards in Internet Explorer then you can see this option.

Regards,

jagan.

Re: Export into excel Problem

drojasromero — Mon, 21 Dec 2015 11:10:35 GMT

This works great for me in QV server:

Export Current Selections to Excel by Default

Re: Export into excel Problem

Bill_Britt — Wed, 23 Dec 2015 02:11:13 GMT

His screen shot was of the Plugin Client.

Bill