Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

Export into excel Problem

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

Tags (2)
12 Replies
MVP
MVP

Re: Export into excel Problem

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).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Export into excel Problem

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

Hi Surender,

Did you try this in your file?

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

Picture2.jpg

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

Picture3.jpg

This link also helpful for you

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

Not applicable

Re: Export into excel Problem

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

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

mentioned in 2nd picture

MVP
MVP

Re: Export into excel Problem

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.

Not applicable

Re: Export into excel Problem

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

Accesspoint.png

thanks

MVP
MVP

Re: Export into excel Problem

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.

Not applicable

Re: Export into excel Problem

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

Community Browser