topic Re: Different type of null in QlikView

Different type of null

smilingjohn — Wed, 23 Dec 2020 10:23:21 GMT

Hi All,

I have different type of nu in my data whihc i am not able to handle properly one or the other keep missing .

In my data I have empty cell some is described as null and some are described within bracket (null) i dont know how do i handle this .

I treid cinverting in the script like belo

If (isnull(ID),'null') as ID

but this is missing (null)

Can please someone help me wiht this ?

Thanks in Advance

Re: Different type of null

Anil_Babu_Samineni — Wed, 23 Dec 2020 10:43:38 GMT

Before raise concern please read blogs from existing via google. anyway, you can try many ways only thing whether you have real null values or not?

If (isnull(ID),'null') as ID

If (Len(ID)=0,'null') as ID etc.

Re: Different type of null

smilingjohn — Wed, 23 Dec 2020 12:08:37 GMT

@Anil_Babu_Samineni sure will search for existing blog for future concerns .

I am confused when u say "Check wheather null values do exist " what exactly do you you mean by this ?

Thanks

Re: Different type of null

marcus_sommer — Wed, 23 Dec 2020 12:24:25 GMT

NULL is a special construct within many databases / programming tools and does mostly not include missing/empty values. Therefore worked isnull() only by real null(). In many cases is no differencing between the various kinds of NULL necessary / needed and therefore you could usually apply a simple check on the length like:

len(trim(FIELD))

- Marcus