topic Re: unlogical issue in QlikView

unlogical issue

Wed, 04 Jul 2012 12:24:20 GMT

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)

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???

Re: unlogical issue

MayilVahanan — Wed, 04 Jul 2012 12:31:51 GMT

hi,

try this,

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

Hope it helps

Re: unlogical issue

jonathandienst — Wed, 04 Jul 2012 12:39:00 GMT

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

Re: unlogical issue

hic — Wed, 04 Jul 2012 18:24:14 GMT

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