Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sculptorlv
Creator III
Creator III

How to convert null() to 0

Hello..

I have data in my LOAD statements, where one Employee have a value while another has not any records about it.

How can I convert null() values to 0

I have tried the LOAD statement bollow, but it doesn't help.. one employee still has "-" value instead of 0

Load

  Employee,

  IF(Coffee_Rent = null(),0, Coffee_Rent) AS Coffee_Rent

RESIDENT Another_Table.

11 Replies
sculptorlv
Creator III
Creator III
Author

I am not sure how to use it..

3.jpg

And the result is the same:

1.jpg

sculptorlv
Creator III
Creator III
Author

Thank you all guys!

I found my problem!

I used two parameters for Employees with the help of JOIN. As the result, for some Employees were not presented in the first LOAD statement.

For my needs I started with the full list of empoyees and then  sed rangesum function.