Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

converting nulls to 0 for a column generated by concatanation

Hi All,

Am new to Qlikview, am stuck in a scenario where I have loaded two tables (logically one) through concatenation. now, for the columns in second table , the rows corresponding to first table have null (-s). I want to convert these to 0s wherever there is a null, right into the load script.

ISNULL isnt working as nulls are generated through non presence of values during concatenation.

Please provide sugessions.

Thanks in advance

3 Replies
Not applicable

How many columns do are not shared between the two tables?

Not applicable

use NullAsValue and NullValue.

Not applicable

Juan is correct. You only need to determine the scope to which you want this behavior to apply: all tables or just these two tables. You will need a 'Set NullValue = 0;' statement and 'null as value [list of columns or *];' statement. As indicated, you can list the specific columns you want to apply the replacement to our have QV do it for all columns. You can also add a 'NullasNull' statement to revert to Qv's default null handling. The placement of the 'NullasValue' and 'NullasNull' statements will determine the tables impacted by the null replacement behavior.