unlogical issue

[#1]

Hi All,

i have an excel sheet and i load the data from it in a qlikview document

there's some data fields in the excel sheet don't have values (blank fields)

like

Number	Name
1
2	x
3	y

the first name is empty

in qlikview i want to use this expression

if ( Name = Null() , 0 , 1 ) in a straight table

but the result of the expression for all rows is 1

that's meaning this empty field isn't null

i tried also

if ( Name = ' ' , 0 , 1 )

but the same result

So, what's the value may be taken in this field???

[MayilVahanan]

hi,

     try this,

     if(len(trim(Name)) =0, 0, 1)

     Hope it helps

[jonathandienst]

Hi

Not really unlogical. In SQL and in Qlikview, null (meaning unknown or undefined) is not the same an empty string, which has a defined state. For an empty string, you can use len() as in the previous post.

Or if you want to make the blanks genuinly null, use

Set NULLINTERPRET= ='';

Hope that helps

Jonathan

[hic]

Further, the expression Name = Null() will never work. NULL cannot be used in comparisons. See more on http://community.qlik.com/docs/DOC-3155.

HIC