Keep Specail characters

[BI_Dev]

Hi - How can I keep special characters in Qliksense ? I gave a address field which has special char in the data, but in the dashboard it shows differently.

Ex: Raw data - Hemvärnsgatan 9

but in Dashboard it shows as - Hemv?rnsgatan 9.

How can I retain the raw data here ?

Thank you much.

[Chanty4u]

Try this 

SubField(Address, ' ', 1) & ' ' & SubField(Address, ' ', 2)

[BI_Dev]

This will not work as Address has different types of charecters...I want this to be dynamic where it pulls in the raw data as is..

[Digvijay_Singh]

Whats your source for this data? When I loaded it though inline table, it shows okay in the KPI chart.

Load * inline [
string
Hemvärnsgatan 9
];

[Chanty4u]

What is your expected output?

You can use 

Keepchar (fieldnam,'*':;!"??*,.') as fieldname

Here you can provide your special characters

[marcus_sommer]

A lot of reasons are possible, for example an inappropriate (configured) data-base driver which prevents that data are loaded with the right char-set. Another possibility is the used font which may not have these special chars and/or a wrong collation-setting is applied (see in the help/community for: CollationLocale). Probably there are more causes possible.

At first you need to find the real cause before you could adjust any logic.

[BI_Dev]

Hi - Data id from .csv file.