Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjanasou
Contributor II
Contributor II

Empty Values in Table view but not NULL

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

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Maybe you can check if the fields contain something strange, maybe none ASCII characters, maybe to many characters?

Jordy

Climber

Work smarter, not harder

View solution in original post

13 Replies
JordyWegman
Partner - Master
Partner - Master

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

Work smarter, not harder
anushree1
Specialist II
Specialist II

It could be a space in the column can u try loading column using like

trim(IMRCD-US) as IMRCD-US

JordyWegman
Partner - Master
Partner - Master

Good reply, but your trim() function will fail when it encounters a real null value. That is why I added the & ''.

Jordy

Climber

Work smarter, not harder
sanjanasou
Contributor II
Contributor II
Author

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

JordyWegman
Partner - Master
Partner - Master

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:

2019-05-16 15_03_11-Qlik Sense Desktop.png

Jordy
Climber

Work smarter, not harder
sanjanasou
Contributor II
Contributor II
Author

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

JordyWegman
Partner - Master
Partner - Master

Does it happen on the same rows? Or is it random? What happens if you only load 50 rows for example?

Jordy
Climber

Work smarter, not harder
sanjanasou
Contributor II
Contributor II
Author

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)

 

JordyWegman
Partner - Master
Partner - Master

Maybe you can check if the fields contain something strange, maybe none ASCII characters, maybe to many characters?

Jordy

Climber

Work smarter, not harder