Replacing Null Values not working

Tue, 30 Apr 2013 13:34:51 GMT

Hello - this is a snippet from my code. I cannot get the nulls to populate the no payments. I have tried a number of techniques (isNull, len=0, combinations of resident tables etc) but to no avail. Please can you help.

Many thanks, James.

NO_PAYMENT_MAP:
MAPPING LOAD
null(),'NO PAYMENTS'
AUTOGENERATE 1;
 
map "Last_Paid" using NO_PAYMENT_MAP; //not sure about quotation marks, single quotes, or nothing at all.
 
PAYMENTS:
LOAD Document_Type, 
     date(Posting_Date) as Posting_Date, 
     CA, 
     Amount as Amount_2
     
FROM

(qvd)
where Exists(CA)
;

MAX_DATE:
Load
 CA,
  date(max(Posting_Date)) as Last_Paid
  Resident PAYMENTS
 Group By CA
 ;
 
MAX_DATE_2:
NoConcatenate
Load
CA,
Last_Paid

//I also tried... if(isNull(Last_Paid), 'No Payment', Last_Paid) as Last_Paid
Resident MAX_DATE
;

DROP TABLE MAX_DATE;
 
MAX_DATE_FINAL:
NoConcatenate
Load *
Resident MAX_DATE_2;

DROP TABLE MAX_DATE_2;

topic Replacing Null Values not working in QlikView

Replacing Null Values not working