Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gaurav2017
Contributor II

Null as "0"

How to treat null values as 'o' in order to make calculations

7 Replies
Not applicable

Re: Null as "0"

script or presentation ?

gaurav2017
Contributor II

Re: Null as "0"

Script

gaurav2017
Contributor II

Re: Null as "0"

Should i be

Set NullDisplay=;

NullAsValue *;

jason_michaelid
Honored Contributor II

Re: Null as "0"

Have a look at my explanation of NULL values and how to deal with them here -

http://community.qlik.com/message/238563#238563

Hope this helps,

Jason

Not applicable

Re: Null as "0"

Jason post a good idea

or you can just use if(isnull(sssssssssssss)) function

jason_michaelid
Honored Contributor II

Re: Null as "0"

Be careful with IsNull() over a large recordset though - see Nicolas' comments here:

http://community.qlik.com/message/237970#237970

Not applicable

Re: Null as "0"

thanks a lotSmiley Happy

Community Browser