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

[alexandros17]

You must set in the script dummy values for null in order to make it selectable in your tables ...

[Anonymous]

Is it possible through expression at UI?

[alexandros17]

You can use something like:

If(Isnull(Sum(MyValue)), 'NO', Sum(MyValue))

and in multibox you can set a similar expression

[sasikanth]

HI

Please go through the thread ,

NULL handling in QlikView

you may fing ans to your questions

[kushalthakral]

Hi Balraj

you can restrict them in the script itself like using Load * from where Col 2=null

This is the dummy code just to give u an overview about that

Regards

Kushal Thakral

[Anonymous]

I have to display only those value where they are null in the table.

I am not asking to use aggregate function...

[alexandros17]

In a dimension you mean? In that case use :

If(Isnull(MyField), 'NO', MyField)

[Anonymous]

Yes, If one dimension(D1) is null than I have to select other dimension(D2) values for those null values.

Above expression is not working...

[alexandros17]

Obviously you put your field name in place of MyField....