Load data with polish characters from .QVD file created using macro

[vaishnavi_m]

I have a data column with some Polish characters (ó, ł, ń, ś, ź, ć). When using this data directly into the QlikView, the characters are shown in application.

When the data is loaded from source and then written to a .QVD file using 'Store' command, the polish characters are shown in the application chart.

When this chart data column is exported into the .QVD using 'macro' below, the polish characters are replaced by '?':

sub exportInToQVD
set obj = ActiveDocument.GetSheetObject("TB01")
obj.Export "C:\Users\user\Desktop\Data.qvd(qvd)", 4
end sub

Qlikview Version 9

What are the steps to follow in order to debug the issue?

[marcus_sommer]

Try it with:

sub exportInToQVD
set obj = ActiveDocument.GetSheetObject("TB01")
obj.ExportEx "C:\Users\user\Desktop\Data.qvd", 4,,,65001 'fifth parameter to define the used charset
end sub

- Marcus

[vaishnavi_m · Accepted solution]

I have found the cause for this. QlikView version 9 does not support the polish characters loaded through QVD created using macro.

Resolution: Upgrade QlikView 9 to the newer version (QlikView 11 or QlikView 12)