How to restrict the null values from the facts at the script level,

[#1]

Hello everyone,

Can anybody tell how to restrict the null value at the script level,

i am using Len(Fact)<>0 and and Not IsNull(Amount).

but it is not working,

Please help into this,

Thanks in advance

[Anonymous]

What kind of not working ?

Could you paste in your actual script ?

[its_anandrjs]

Hi,

You are using the correct functions also read this document

NULL handling in QlikView

Regards

Anand

[#4 · Accepted solution]

I used Len(Fact)<>0, but it is only (Fact)<>0, Len function should not used

[sakamsureshbabu]

you can use same exp in calculation dimension