
Partner - Contributor III
2024-01-17
11:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Replace null values with 0 dynamically
I have a table that each once in a while we add a new column, i cannot keep adding columns one by one putting that if( isnull(), 0, column) as column
i want to turn it to do it dynamically for all the columns of the table whenever there is null value replace it with 0
How?
- Tags:
- null values
625 Views
1 Reply

Partner - Creator III
2024-01-17
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
NullAsValue *;
SET NullValue='0';
regards,
QlikView Qlik Sense consultant
