Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IsNull on Dimension and Expression

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

***            ***          -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.

4 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

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

q.png

I'm attaching the sample qvw...

Not applicable
Author

Thank you Fernando,

Your sample qvw in my QV 10.00.9519.9 SR5 does this :

2013-01-09_17h06_00.png

fosuzuki
Partner - Specialist III
Partner - Specialist III

It seems like a bug...

Have you tried with SR6?

Not applicable
Author

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).