topic SelectionStampInBIFFExport=1 in QV Server 12.20 in Archived Groups

SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Wed, 23 Jul 2025 14:48:52 GMT

Hey everyone,

I'm in the process of moving to a new machine and also upgrading from 11.120 to 12.20. The only thing I'm missing and can't get to work is to have the selections at the end of an Excel sheet when exported from an app.

I did as I did on my old server (and is also described here) and added to C:\ProgramData\QlikTech\QlikViewServer\settings.ini the following line (03):

[Settings 7]
...
SelectionStampInBIFFExport=1
...
[Authentication]
...

After restarting the server service it still does not work. Has anyone encountered this before? I can't get this to work but really need it.

Thanks,

-Stefan

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

Anil_Babu_Samineni — Sat, 25 Nov 2017 10:03:15 GMT

Can you try BIFF Code using Macro in Excel like, and then we can investigate or test in QlikView

Sub Macro_Export_Edit()

Dim wb As Workbook

Set wb = Workbooks.Open("S:\Client\Assumptions.xls", UpdateLinks:=0, ReadOnly:=False)

wb.Sheets(1).Range("A1").Activate

ActiveCell.Value = 1

wb.ChangeFileAccess Mode:=xlReadWrite

End Sub

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

marcus_sommer — Sun, 26 Nov 2017 15:41:07 GMT

I could imagine that this parameter isn't valid anymore because with 12.2 the excel-default format by exporting is now xlsx and not xls. By loading data into qlik the file-format changed from biff to ooxml regarding to xls vs xlsx. You could try just replacing it within the parameter. Otherwise some hint from the qlik-side will be needed.

SelectionStampInOOXMLExport=1

- Marcus

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Sun, 26 Nov 2017 15:57:39 GMT

This throws a runtime error 1004 at

wb.ChangeFileAccess Mode:=xlReadWrite

when I run this sub in Excel and have Workbooks.Open() point to an actual Excel file.

Maybe I don't understand correctly what you're suggesting.

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Sun, 26 Nov 2017 15:58:37 GMT

Good point! I tried it with OOXML, XLSX, XLS and Excel instead of BIFF but none of those worked.

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Sun, 26 Nov 2017 16:13:11 GMT

I did some more testing and found that it's not working in the local client as well although it's enabled in the User Preferences. This is very troubling. Can anyone confirm?

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

marcus_sommer — Sun, 26 Nov 2017 16:17:59 GMT

Try to change this option within the local qlikview desktop client and then take a look within the settings.ini from the client - the used parameter should be listed there.

- Marcus

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Sun, 26 Nov 2017 16:23:29 GMT

There it's still the old one:

SelectionStampInBIFFExport=1

However, as stated below, it's also not working in the client for me.

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

rwunderlich — Mon, 27 Nov 2017 01:53:17 GMT

It's not working for me either. I would take this to QT Support.

In the meantime, if you want a workaround to return to old xls method, there is a switch:

SendToExcelLegacyFormat=1

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Mon, 27 Nov 2017 05:27:52 GMT

Thanks, Rob! Now I at least have selection stamps in my exports.

I'll go ahead and report this to QT Support.

Re: SelectionStampInBIFFExport=1 in QV Server 12.20

steeefan — Tue, 28 Nov 2017 13:33:21 GMT

Ticket 01262068