topic Re: IsNull on Dimension and Expression in QlikView

IsNull on Dimension and Expression

Wed, 09 Jan 2013 10:21:33 GMT

Hello,

I've got some troubles with isNull() function.

IsNull() doesn't return the same values when I use it in expressions or dimensions in chart table.

Here is my test :

Dimensions :

Dim1 : =Null() => Result : ***

Dim2 : =IsNull(Null()) => Result : -1

Dim3 : =IsNull([Name]) => Result : *** when name is null or 0 when name is not null

Expression :

Exp1 : =IsNull([Name]) => Result : -1 when name is null or 0 when name is not null

Presentation parameters of the chart table are :

Null symbol : "***"

Missing Symbol : "-"

Result looks like this :

NAME DIM1 DIM2 DIM3 EXPR1

Robin *** -1 0 0

Martin *** -1 0 0

*** *** -1 *** -1

John *** -1 0 0

So, I've 3 questions :

- I observe it with QV10 SR5, and I've never had this trouble with SR3. Has anything changed?

- In dimensions : Why IsNull(null()) works and not IsNull([Name])?

- Why IsNull([Name]) works differently in expression and in dimension?

Thanks.

fosuzuki — Wed, 09 Jan 2013 15:51:59 GMT

Hi, tested in QV11.0.11440 (SR2 Update 2) and Dim3 is equal to Expr1....

I'm attaching the sample qvw...

Wed, 09 Jan 2013 16:09:56 GMT

Thank you Fernando,

Your sample qvw in my QV 10.00.9519.9 SR5 does this :

fosuzuki — Wed, 09 Jan 2013 16:20:02 GMT

It seems like a bug...

Have you tried with SR6?

Thu, 10 Jan 2013 09:04:53 GMT

No I haven't tried SR6

I've contacted the support, and it seems like a bug. I think I'll have to update my QV.

I'll post support's answer(s).