Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
haneeshmarella
Creator II
Creator II

Not able to use IF condition for NULL rows

Hi guys,

I have a field called CONTAINER. If it is NULL, it is OFFLINE and if it is NOT NULL, it is ONLINE. I've tried multiple IF conditions to get the options of ONLINE and OFFLINE based on the data but OFFLINE never shows up although there are NULL values in that field.

If(CONTAINER IS NULL,'OFF-LINE','ON-LINE')

If(CONTAINER = ' ','OFF-LINE','ON-LINE')

If(CONTAINER LIKE '%99%','ON-LINE','OFF-LINE')

If(CONTAINER <> ' ','ON-LINE','OFF-LINE')

IF(ISNULL[CONTAINER],'OFF-LINE','ON-LINE')


Can you please help me what minute mistake am I making? Also, any alternative like loading them separately?

1 Solution

Accepted Solutions
sunny_talwar

Try this

If(Len(Trim(CONTAINER)) = 0, 'OFF-LINE', 'ON-LINE')

View solution in original post

2 Replies
sunny_talwar

Try this

If(Len(Trim(CONTAINER)) = 0, 'OFF-LINE', 'ON-LINE')

haneeshmarella
Creator II
Creator II
Author

Thank you Sunny