Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
deena279
Contributor
Contributor

I am new to Qlikview. i have a query

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

2 Solutions

Accepted Solutions
zhadrakas
Specialist II
Specialist II

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 

View solution in original post

zhadrakas
Specialist II
Specialist II

perfect. glad i could help.

please mark the answer as accepted.

regards

tim

View solution in original post

3 Replies
zhadrakas
Specialist II
Specialist II

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 

View solution in original post

deena279
Contributor
Contributor
Author

Thanks Tim. This helped to fix the issue

zhadrakas
Specialist II
Specialist II

perfect. glad i could help.

please mark the answer as accepted.

regards

tim

View solution in original post