topic Re: converting nulls to 0 for a column generated by concatanation in QlikView

converting nulls to 0 for a column generated by concatanation

sonikajain — Mon, 16 Apr 2012 15:30:21 GMT

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

converting nulls to 0 for a column generated by concatanation

Mon, 16 Apr 2012 15:51:28 GMT

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

converting nulls to 0 for a column generated by concatanation

Mon, 16 Apr 2012 15:55:36 GMT

use NullAsValue and NullValue.

Re: converting nulls to 0 for a column generated by concatanation

Mon, 16 Apr 2012 16:03:58 GMT

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.