Strange issue with null records

[qlikviewwizard]

Hi All,

I am unable to handle NULL records in scripting.

For example Ename-WARD has the SAL and COMM in Q1 but no data in Q2.

When I select Q2 for WARD records showing '--'.

For SMITH COMM is 0 in Q1 and % is '--'.

Screen:

I want to show NULL values to zero in the script.So that I can see 0% in the report for Q2 as well.

Please help me.

Enclosed the app. for your reference.

Thanks in advance.

[qlikviewwizard]

Hi Folks, Any solution?

[#3]

to handle the null values, u can use if conditions in expressions. Like,

% -  If(isnull(Column(1)/Column(2)), 0, Column(1)/Column(2))

[qlikviewwizard]

Hi kSindhuKannan

I tried this.

But for Q2 WARD is getting '--' values.

Please check. !

[Anonymous]

PFA

[qlikviewwizard]

Hi ravic906 ,

Thank you for your solution. But % is not showing for 0 values. Could you advise?

[er_mohit]

Hi

if you want to show - null values to 0 in chart then there's an option in chart table properties.

Go to Properties-->presentation tab--> below you find null value symbol replace it with 0

hope it helps

[Anonymous]

Populate missing values

[#9]

Hi i think u can use this

[jagan · Accepted solution]

Hi,

Give 0% in Presentation tab-> Null and Missing Symbols option.

Regards,

Jagan.