topic Re: How to use Alt function to check whether field is null in QlikView

How to use Alt function to check whether field is null

juntiporn_k — Sun, 17 Jan 2016 12:41:44 GMT

How to use Alt function to check whether field is null or not null.

Re: How to use Alt function to check whether field is null

sunny_talwar — Sun, 17 Jan 2016 14:52:44 GMT

May be this:

Alt(FIELD1, FIELD2) as Result

Here if FIELD1 is Null, then you will see FIELD2, else you will see FIELD1

QlikView help on Alt: QlikView ‒ alt - script and chart function

Re: How to use Alt function to check whether field is null

nancypoliti — Mon, 14 Nov 2016 21:49:17 GMT

This is only true for fields with NUMBERS. If Field1 is a non null string, Field2 will be returned.

Re: How to use Alt function to check whether field is null

sunny_talwar — Mon, 14 Nov 2016 23:52:27 GMT

Thanks for pointing that out . I always thought that it works for number and text, but it seems to be something which can be used for numbers only.

Re: How to use Alt function to check whether field is null

nancypoliti — Tue, 15 Nov 2016 14:27:16 GMT

Yes, I lost 4 hours of my life to this, thinking that it worked on strings as well as numbers.

Alt(Field1, Field2, Field3, ...) will return the first valid NUMERIC value from the list in the parentheses. It's dangerous to think of it as just a test for NULL.

Re: How to use Alt function to check whether field is null

Anonymous — Thu, 12 Jan 2017 07:29:40 GMT

i have Ten employee Id. but 6 employees only present today. 4 employees not present. i want to 10 employees worked hours, here 6 employees based on working hours and 4 employees set 0? how to do