Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi, tested in QV11.0.11440 (SR2 Update 2) and Dim3 is equal to Expr1....
I'm attaching the sample qvw...
Thank you Fernando,
Your sample qvw in my QV 10.00.9519.9 SR5 does this :
It seems like a bug...
Have you tried with SR6?
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).