I am new to Qlikview. i have a query

[deena279]

I am new to Qlikview. A resident table is left joining with .csv file. one of the columns in resident table have null value. i need a query to show the null values in column to be mark as a "others" in the second column

[zhadrakas · Accepted solution]

before the resident load add:

 NullAsValue YOUR_COLUMN; SET NullValue = 'others';

then try to join the csv.

Note that Nullasvalue and NullValue only works on Resident load!

regards

tim 

[deena279]

Thanks Tim. This helped to fix the issue

[zhadrakas · Accepted solution]

perfect. glad i could help.

please mark the answer as accepted.

regards

tim