Value NULL in set analysis?

[antoniotiman]

Hi,

How can I set value NULL  in set analysis?

sum({<CostoVen={NULL}>} Sales)   [convert from sum(if(IsNull(CostoVen),Sales)]

Tanks You

[Nicole-Smith]

I'm guessing NULL would be the opposite of "is something":

sum({$-<CostoVen={'*'}>} Sales)

or

sum({$-<CostoVen={'?*'}>} Sales)

where $- means "not" and '*' or '?*' means "something"

[antoniotiman]

Thanks.  I'm also going to try sum({$-<CostoVen={"%*%"}>} Sales).

[jpapador]

You could also make a null flag in your script.

If(Len(CostoVen) = 0, 1, 0) as NullFlag

Than your expression would look like this

sum({$<Nullflag={1}>} Sales)

[Nicole-Smith]

I'm not sure what you're trying to do with the percent (%) signs.  In QlikView the wildcards are asterisk (*) for zero or more characters and question mark (?) for one single character.

[antoniotiman]

sum({$-<CostoVen={"%*%"}>} Sales) is OK.

Thanks.

[kiranmanoharrode]

Hi Antonio

Try this

=sum({<CostoVen={""}>} Sales)

Regards

Kiran

[CELAMBARASAN]

You could use the expression as below

Sum({<CostoVen-={"*"}>} Sales)

[antoniotiman]

I could also make script :

NullAsValue CostoVen;

SET NullValue = 0;

but I cannot modify the script because of file.qvd very great that would not be adjourned.

[antoniotiman]

Hi Kiran,

I have already tried. It doesn't work.

Thanks