topic Menage null value in QlikView

Menage null value

Tue, 27 Apr 2010 14:26:35 GMT

Hello,

i need to menage a null in where statement:

load

...

Where Amount <> Null() ;

if I use this statement do ot work. Infact in the Amount cel I found :

"-"

also if I write <> '-'

do not work ...

thanks

Regards

Slash

Menage null value

Tue, 27 Apr 2010 14:59:44 GMT

hi,

probably you should use

load

...

Where Amount ;

thanks

Menage null value

Tue, 27 Apr 2010 15:16:57 GMT

it doesn't work..

Look at this sample:

number

date

Paul

20490

13/11/2009

Paul

20492

13/11/2009

Paul

20494

13/11/2009

Paul

13/11/2009

I need to eliminate this row:

Paul

13/11/2009

by Where statement

thanks

Menage null value

Tue, 27 Apr 2010 15:48:15 GMT

You can try this :

LOAD

.......

WHERE len( Amount ) > 0 ;

Regards

Benoît

Menage null value

tizianacaem — Tue, 27 Apr 2010 16:06:11 GMT

Hi,

try with the instruction IsNull, that returns the value -1 if the filed is null.

So if you have to show the records that have Amount not null, you can use:

if (isNull(Amount)<>-1, .....

hope to be useful

Menage null value

Tue, 27 Apr 2010 18:55:54 GMT

hi,

pls see the attached application and the excel file.

probably this is what u want

thanks

Menage null value

Tue, 27 Apr 2010 18:58:37 GMT

hi,

pls see the attached application and the excel file.

probably this is what u want

thanks

Menage null value

Tue, 27 Apr 2010 19:00:08 GMT

hi,

this is the excel file

tahnks