IF(ISNULL... working for one field but not the other!

[matthewp]

I have four lines in my load script.

     [table1.ONumber] AS [O Number]

     if(isnull([table1.ONumber]),'Missing','Ok') AS [T1O Check],

and

     [table2.PNumber] AS [P Number]

     if(isnull([table2.PNumber]),'Missing','Ok') AS [T2P Check],

The first one returns data as it should

O Number     T1O Check

OO 123 IM    Ok

OO 435 IM    Ok

                    Missing

OO 358 IM    Ok

OO 329 IM    Ok

However the second one isn't treating the nulls as it should

P Number     T2P Check

PP 123 IM    Ok

PP 435 IM    Ok

PP 358 IM    Ok

PP 329 IM    Ok

The code works fine if used in an expression in a straight table chart, just not in my load script.

[Anonymous]

if(field name ='value',give the condition, given condition,

if(field name='value' give the condition, give condition))

[alexandros17]

Maybe you have no null values, try to add this piece of code:

if(isnull([table2.PNumber]) or Trim([table2.PNumber])='','Missing','Ok') AS [T2P Check])

let me know

[Gysbert_Wassenaar]

Try this: If(Len(Trim([table2.PNumber]))=0,'Missing','Ok') AS [T2P Check],

[matthewp]

Still the same issue

[matthewp]

Still the same issue

[matthewp]

The code works fine if used in an expression in a straight table chart, just not in my load script.

[matthewp]

The code works fine if used in an expression in a straight table chart, just not in my load script.

[Gysbert_Wassenaar]

I don't see how that's possible unless you have very strange characters in that field. Please post a small qlikview document that demonstrates the problem.

[sunny_talwar]

Can you do something like this:

Ord([table2.PNumber]) as Character to check what exactly it is that is hidden?