Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Changing null values to 1's upon script load

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:

Capture.PNG

**"EXCEPTION CODE" is actually "Exception Code bidf"

1 Solution

Accepted Solutions
Highlighted
1 Reply
Highlighted