Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to include only null values in Set Expression

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"

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try(not tried myself though):

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

Or,

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

View solution in original post

5 Replies
sasiparupudi1
Master III
Master III

Try

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

tresesco
MVP
MVP

May be like:

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

Kushal_Chawda

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

Not applicable
Author

They work individually but not when combined

tresesco
MVP
MVP

Try(not tried myself though):

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

Or,

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