topic Re: Strange issue with null records in QlikView

Strange issue with null records

qlikviewwizard — Wed, 08 Jul 2015 02:45:53 GMT

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.

Re: Strange issue with null records

qlikviewwizard — Wed, 08 Jul 2015 06:28:09 GMT

Hi Folks, Any solution?

Re: Strange issue with null records

Wed, 08 Jul 2015 06:36:32 GMT

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

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

Re: Strange issue with null records

qlikviewwizard — Wed, 08 Jul 2015 08:10:52 GMT

Hi kSindhuKannan

I tried this.

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

Please check. !

Re: Strange issue with null records

Anonymous — Wed, 08 Jul 2015 08:26:17 GMT

PFA

Re: Strange issue with null records

qlikviewwizard — Wed, 08 Jul 2015 08:42:11 GMT

Hi ravic906 ,

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

Re: Strange issue with null records

er_mohit — Wed, 08 Jul 2015 08:51:42 GMT

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

Re: Strange issue with null records

Anonymous — Wed, 08 Jul 2015 08:54:42 GMT

Populate missing values

Re: Strange issue with null records

Wed, 08 Jul 2015 08:56:41 GMT

Hi i think u can use this

Re: Strange issue with null records

jagan — Wed, 08 Jul 2015 09:06:56 GMT

Hi,

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

Regards,

Jagan.