Current Selections in Export To Excel

[HimanshuKakade]

Hi,

We have a dashboard with some tables and chart.

We have checked both the check boxes from User Preferences > Export > Selection Stamps in Exports

When we export the table or chart to Excel from Qlikview Desktop, we are able to get the current selection displayed in the Excel Export.

But, when we publish the same dashboard from Management Console and when a user access it from Access Point & export the table to Excel, the Current Selection is not displayed in the Excel.

We are using Qlikview 12.20.

Kindly guide.

[Josh_Berg_Support]

Can you post screenshots that show us the issue you're experiencing with the Export to Excel function?

Also, keep in mind that Qlikview wasn't designed to be a program to export data to Excel, it is designed to keep all data within the program for manipulation.  Is there a reason users need to export to Excel and can't keep the data within Qlikview?

Thanks,

Josh

Qlik Support

[Vegar · Accepted solution]

You will need to locate your server settings.ini file. I think you normally will find it at this location: %ProgramData%\QlikTech\QlikViewServer\Settings.ini

Somewhere under the [Settings 7] add the following config line:

SelectionStampInBIFFExport=1

[Vegar · Accepted solution]

I even found an Qlik official support document describing how to do it in detail: How to Include Selection Stamps when Exporting to Excel from AJAX