Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have been having some trouble counting items that have been picked when a value is null. It was working until these new updates came around, but I am trying to change the value from null to 1 upon script load. Here is what i am trying so far in the script. The output is still the same. Any ideas to figure this out? In set expression, I tried using the -= '' way, but it is not working either.
SCRIPT:
"Exception Code" AS "Exception Code bidf",
if("Exception Code" = '', 1,"Exception Code") as "Exception Code bidf testing",
"Warehouse Process Cat. Desc." AS "Warehouse Process Cat. Desc bidf",
OUTPUT:
**"EXCEPTION CODE" is actually "Exception Code bidf"
test for null using IsNull(), '' is empty which is not the same....
Other ways to handle NULL
https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/null-value-handling.htm
test for null using IsNull(), '' is empty which is not the same....
Other ways to handle NULL
https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/null-value-handling.htm