topic Re: Load data with polish characters from .QVD file created using macro in QlikView

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

vaishnavi_m — Sat, 16 Nov 2024 20:12:35 GMT

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?

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

marcus_sommer — Fri, 23 Aug 2019 13:49:37 GMT

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

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

vaishnavi_m — Wed, 28 Aug 2019 01:37:35 GMT

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)