Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

martyn_collis
New Contributor

Data loading as ?

Hi All,

I am working on a project whereby my data is being loaded as a "?" instead of the data that is present in the database.

for example, my database has data like this:

AddressIDpropertyname
270Blah
271blah 2
273
......
12548more blahs

Whereas Qlik Sense is loading it as:

AddressIDpropertyname
?Blah
?blah 2
?
......
?more blahs

I cannot work out why the data is loading as it is, source data is coming from a SQL server (2012).

I have verified that the data is correct in the database and is correct in the QVD

This is happening on several tables especially where there is an ID field.

Any ideas experts?

1 Solution

Accepted Solutions
1adam_haj
New Contributor III

Re: Data loading as ?

So the "?" is being seen in the data table model preview ?
Sometimes this could be coused by some badly calculated column, try to load it as standalone column and check the data, if it will be still wrong i would look if there is something wrong with the connection in the data load script

3 Replies
1adam_haj
New Contributor III

Re: Data loading as ?

So the "?" is being seen in the data table model preview ?
Sometimes this could be coused by some badly calculated column, try to load it as standalone column and check the data, if it will be still wrong i would look if there is something wrong with the connection in the data load script

martyn_collis
New Contributor

Re: Data loading as ?

Indeed it was.

It turned out, I neglected to set the linked field as a numeric from nvarchar.

changing the source data SQL to present the linked field as numeric has solved the issue.

1adam_haj
New Contributor III

Re: Data loading as ?

good i think that you could do the same in data load script with num() - alternative to your solution. But your solution worked as well 

Community Browser