Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Empty field on request

Hi,

I have an issue with extracting data from a database.

I realise a SQL request like :

select

myfield1 as myData

from my table

But I receive an empty list of myfield1 even though there is data in this table.


But if i write

select

concat(myfield1, '                                       ') as myData

from my table

It works.

But It only filters data where the length is max the length of with spaces I concat.

Have someone already met this issue ?

Pascal

0 Replies