Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selections shown when export to excel option?

When you print or export to a pdf, the current selections are shown too.  When I export to excel, the current selections are not shown.  Can we, and if so how, can we export to excel with the current selections attached too?

Thanks!

16 Replies
m_woolf
Master II
Master II

Selection Box can be exported with a macro....same as charts listed above.

natebrunner
Contributor III
Contributor III

I realize you can do it with a Macro...was hoping there was a way to do it without Macros. We are on version 9, although hoping to upgrade to 11 this summer. Is it built in functionality in 11 to do it without a Macro?

Not applicable
Author

Well there is a fix on the support site for AJAX, but it breaks the export selections in IE explorer plugin for us (which was working).

How to Include Current Selectionswhen Exporting to Excel from AJAX

               

 

Description

 
             
   

When exporting to Excel you can include    the current selections by activating a user setting in IE-plugin/Desktop.
    To get the same behavior when using AJAX the same setting needs to be    activated server side in the settings.ini file.

   
 
 

Resolution

 
             
   
  • Stop the service "QlikView Server"
  • Open the file settings.ini (located in    C:\ProgramData\QlikTech\QlikViewServer or C:\Documents and Settings\All    users\ApplicationData\QlikTech\QlikViewServer depending on OS)
  • Add the parameter SelectionStampInBIFFExport=1 in the    section labeled [Settings 7]
  • Save the file
  • Restart the service "QlikView Server"
                   
 
 

Tags

 
 

Server/Publisher, AJAX, Export, Excel, Current Selections

 
natebrunner
Contributor III
Contributor III

Interesting. Thanks for the help. Weird that it would fix AJAX but break the plugin. I suppose it's better if we just wait until the upgrade.

brindlogcool
Creator III
Creator III

Hi,

I am using ExportEx to export to excel the current selection is getting exported in to excel. I have unchecked the selection timestamp in the user preference but still the current selection is shown. I tried the macro in the Api guide to set the selection time stamp to false. Is ther any way i can stop this

michaelfreitas
Creator
Creator

In the development version of QlikView have this option.

Good!

mayankraoka
Specialist
Specialist

Hi,

Can the current selection should be on top possible?

Regards,

Mayank