Qlik Community

Qlik Sense App Development

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

vasiliy_beshent
Contributor III

I got "???? ??????"

Hello again, everyone!

In one application that was developed not by me i have reload data and got "???? ?????" instead of data.

How to repair it?

2017-02-17 15_13_37-_Controlling_new(1) _ Просмотр модели данных - Qlik Sense.png

12 Replies
MVP
MVP

Re: I got "???? ??????"

May be add Text() function around your fields while loading

LOAD Text(Field1) as Field1,

           ....

FROM ...

vasiliy_beshent
Contributor III

Re: I got "???? ??????"

No reaction

MVP
MVP

Re: I got "???? ??????"

Is the data from SQL query?

vasiliy_beshent
Contributor III

Re: I got "???? ??????"

Yes

MVP
MVP

Re: I got "???? ??????"

May be add Text() function equivalent of SQL function in the select statement?

vasiliy_beshent
Contributor III

Re: I got "???? ??????"

What do you mean? When i execute query in ssms it's absolutely ok. I can't understand what happened that data became ????? ?????

gareth_wilson12
Contributor II

Re: I got "???? ??????"

If you export the data from Qlik to Excel do you get the right values or still ????

vasiliy_beshent
Contributor III

Re: I got "???? ??????"

Still

2017-02-17 16_07_58-Microsoft Excel - 7601f9f3-3944-4bbc-8f83-8d3fdd17aa92.png

MVP
MVP

Re: I got "???? ??????"

See if this thread offer any help:

Multiple Question mark in list box