Discussion board where members can get started with QlikView.
Is there a setting I can change to treat nulls as a zero in calculations found in my scripts?
I've used if(isnull(field1)=0,field1,0)
However it tends to make my script run longer.
I've just seen Alt(field1,0) method and plan on testing it out.
Are there any other ways to have the script interpret a field as zero with minimal impact to load times?
I'd prefer to simply used a SET statement and have QV simply interpret nulls as zeros however I haven't seen anything like this.
You could look into NullAsValue script statement and NullValue variable:
Have you tried to run this way?