How to select records corresponds to null values?

[Anonymous]

Hello All,

I am having a table say

Tab1:

Col1, Col2

a1, 1

a2,

a3, 2

a4,

a5, 3

Now I have to select those column's value from Col1 where Col2 is null in Qlikview.

Can we get it using expression or we need to work at backend?

Regards,

Balraj

[Anonymous]

Yes, I have put my field name only...

[er_mohit]

See the attached file

[alexandros17]

Are you sure they are Null?

please try the following and let me know ...

If(Isnull(MyField) or Trim(MyField)='', 'NO', MyField)