topic Re: null values in QlikView

null values

ssriramin19 — Thu, 17 Aug 2017 12:12:28 GMT

Hello All,

I have a expression like

IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1)))))

For certain batch id's the values of the expression is null . How to eliminate the null values in the table.

Can any one please suggest me how to eliminate the null symbol

Thanks

Sriram

Re: null values

ahaahaaha — Thu, 17 Aug 2017 12:20:47 GMT

Hi,

May be change representation value NULL to zero?

Regards,

Andrey

Re: null values

ssriramin19 — Thu, 17 Aug 2017 12:23:49 GMT

The above suggestion works but is there option to re write the expression using is null statement. I just looking at other possibilities ..

Kindly advice

Thanks

Sriram

Re: null values

ahaahaaha — Thu, 17 Aug 2017 13:30:40 GMT

May be field name change to expression, like this

If(IsNull([YourFieldName])=-1, 0, [YourFieldName])

Andrey

Re: null values

ssriramin19 — Fri, 18 Aug 2017 08:21:40 GMT

I must not show any corresponding dimension values and related expression values also.

Kindly suggest some approach.

Thanks

Sriram

Re: null values

ssriramin19 — Fri, 18 Aug 2017 09:36:55 GMT

I will try on this option , thanks for the suggestion

Re: null values

Peter_Cammaert — Fri, 18 Aug 2017 11:33:59 GMT

In a straight table, a row will disappear if all expression columns either produce NULL or 0. You can force this by testing the value of expression column Hit% by name. For example, in the next expression, you can use:

=IF (Not IsNull([Hit%]), ExpressionForThisColumn)

which will also result in a NULL value if column Hit% contains NULL.