topic Re: How to include only null values in Set Expression in QlikView

How to include only null values in Set Expression

Thu, 17 Sep 2015 10:02:11 GMT

I have a set expression that works fine. It excludes the Null values and shows the correct result

only({<ServerName-={''}>} ServerName)

I am looking for the Set Expression to return only Null values. I am not sure what am i missing here but this should work but it is not.

only({<ServerName={''}>} ServerName)

Also how do i combine multiple criteria here like "Only rows where ServerName is Null and HostName is Null"

sasiparupudi1 — Thu, 17 Sep 2015 10:07:00 GMT

Try

only({<ServerName={"$(=Null())"}>} ServerName)

tresB — Thu, 17 Sep 2015 10:09:47 GMT

May be like:

only({$ - <ServerName={'*'}, HostName={'*'}>} ServerName)

Kushal_Chawda — Thu, 17 Sep 2015 10:11:48 GMT

only({ <ServerName-={'*'}, HostName-={'*'}>} ServerName)

Thu, 17 Sep 2015 10:33:09 GMT

They work individually but not when combined

tresB — Thu, 17 Sep 2015 10:38:54 GMT

Try(not tried myself though):

only({$ - <ServerName={'*'}> * $-< HostName={'*'}>} ServerName)

Or,

only({($ - <ServerName={'*'}>) * ($-< HostName={'*'}>)} ServerName)