Discussion Board for collaboration related to QlikView App Development.
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
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!
View solution in original post
perfect. glad i could help.
please mark the answer as accepted.
Thanks Tim. This helped to fix the issue