Not able to use IF condition for NULL rows

haneeshmarella — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Not able to use IF condition for NULL rows

sunny_talwar — Tue, 10 Jul 2018 13:50:23 GMT

Try this

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

Re: Not able to use IF condition for NULL rows

haneeshmarella — Tue, 10 Jul 2018 13:55:06 GMT

Thank you Sunny

topic Re: Not able to use IF condition for NULL rows in QlikView

Not able to use IF condition for NULL rows

Re: Not able to use IF condition for NULL rows

Re: Not able to use IF condition for NULL rows