
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Replace Null Values for 0
Hi, I'm loading several excel files with diferente fields. I want to create a condition that replace null values for 0.
I know how to do for a specifc field but in this case the name of field can be variable (more then 100 fields) so i want create a condtion for table.
Check Table if null replace to 0.
Anyone has idea how to do it? Thanks in advance
Regards
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can try to add this line. Maybe QlikView dont recognize that the empty cells are real NULL Values.
SET NullInterpret = ‘’;
regards
tim


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this code above your load script.
NullAsValue *; SET NullValue = ‘0’;
regards
tim

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Didnt work. But this is the way


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can try to add this line. Maybe QlikView dont recognize that the empty cells are real NULL Values.
SET NullInterpret = ‘’;
regards
tim

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, solved it!!!!
