Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
sanjanasou
New 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
Partner
Partner

Re: Empty Values in Table view but not NULL

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

Jordy

Climber

Work smarter, not harder
13 Replies
Partner
Partner

Re: Empty Values in Table view but not NULL

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
Valued Contributor

Re: Empty Values in Table view but not NULL

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

trim(IMRCD-US) as IMRCD-US

Partner
Partner

Re: Empty Values in Table view but not NULL

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
New Contributor II

Re: Empty Values in Table view but not NULL

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

Partner
Partner

Re: Empty Values in Table view but not NULL

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
New Contributor II

Re: Empty Values in Table view but not NULL

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

Partner
Partner

Re: Empty Values in Table view but not NULL

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
New Contributor II

Re: Empty Values in Table view but not NULL

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)

 

Partner
Partner

Re: Empty Values in Table view but not NULL

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

Jordy

Climber

Work smarter, not harder