We are looking to display special characters in the dashboard
Example:
German: umlauts: Ä, Ö, Ü and ß
French:
- L'accent aigu (é)
- L'accent grave (à, è, ù)
- L'accent circonflexe or "chapeau" (â, ê, î, ô, û)
- La cédille (ç)
- Le tréma (ë, ï, ü)
Since it was not displaying in QlikView dashboard, thought of replacing with Ascii chars in the extract file and display in the dashboard using the following code
CharMap:
Mapping LOAD
RecNo() - 1 AS Asciicode,
Chr(RecNo() - 1) AS Char
AutoGenerate 256;
Data:
LOAD *,
MapSubString('CharMap', Num) as formattedText
Inline
[
company
220116101115116 ----------This works fine and displays Ütest
1 2 3 ABC company -------------??? ABC Company 1 2 3 is part of the company name but not special char
4 Trading -------------? Trading 4 is part of the company but not special char
]
;
Using QlikView Version 12.6 May 2021 SR2
Data file type: QVX
How do I ignore these so that they are displayed without parsing/mapping?
or
if we have any localization script suggestions that would be appreciated?
