Empty Values in Table view but not NULL

[sanjanasou]

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

[sanjanasou]

too many characters yes could be.

is there a limit for qlik?

[JordyWegman]

There is for numerical values, but not for strings. What does you data model viewer show you? Also empty values?

Jordy

Climber

[sanjanasou]

Actually, it's the size of the text. too big. I tried substring(text,0,100) and the text was showing. So I guess my text is too big and Qlik has limitations .

[sanjanasou]

It's too many characters.
Thanks!