Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that doesn't have any empty fields before being loaded to qlik.
I have just loaded this table simply without joining or concatenating any other table with it.
The strange thing is that in few columns, I am getting empty fields (Not NULL) I was able to filter on them and click on them and that affects an other chart it's like the field has a value. This looks very strange for me.
Have you ever experienced something similar?
Thanks,
SS
Maybe you can check if the fields contain something strange, maybe none ASCII characters, maybe to many characters?
Jordy
Climber
Hi Sanjana,
It seems that there are ' ' or spaces in your data. Try to add this formula in the back-end:
IF(trim([Your Field] & '')= '',null(),[Your Field]) as [Your Field]
// If you do want to click on your 'null' value then to the following:
IF(trim([Your Field] & '')= '','#N/A',[Your Field]) as [Your Field]
Jordy
Climber
It could be a space in the column can u try loading column using like
trim(IMRCD-US) as IMRCD-US
Good reply, but your trim() function will fail when it encounters a real null value. That is why I added the & ''.
Jordy
Climber
Hi,
Thank you guys for your answers.
I tried but still same problem.
Actually the field is not null I can see that one row with same id has really values when i check the table in the database. but once i lod into qlik i dont knbow what happens...
SS
I don't know what really happens, but is really wrong?
See my example. I've made inline table with one empty value and I'm able to select it:
Jordy
Climber
Hi Jordy,
Yes that's not the problem.
The problem is in my case the value should not be empty. In the database it has a value its one full text.
all the rows of the table are not missing any value. But for some reason when i load into qlik, some values disappear...
every text has an id. when I check in my database what is the text associated to that specific id I can see it. But in Qlik it shows empty
/SS
Does it happen on the same rows? Or is it random? What happens if you only load 50 rows for example?
Jordy
Climber
Yes its always same rows. because i loaded data many times and always same ids have empty texts.
I loaded 50 its not there. (that was by chance that none of them is among the first 50)
Maybe you can check if the fields contain something strange, maybe none ASCII characters, maybe to many characters?
Jordy
Climber