topic script to rename a field in QlikView

script to rename a field

Anonymous — Mon, 10 Mar 2014 14:44:28 GMT

Hi folks,

I have a spreadsheet with two different date columns. One is called BookDate, the other is InvoiceDate. I am creating a new field BookActionYear= Year(BookDate) but when BookDate is null, BookActionYear=Year(InvoiceDate).

Could you help me with the script please...?

Re: script to rename a field

maxgro — Mon, 10 Mar 2014 14:47:08 GMT

if(len(trim(BookDate))=0, InvoiceDate, BookDate) as BookActionYear

Re: script to rename a field

srchilukoori — Mon, 10 Mar 2014 14:55:17 GMT

Massimo Grossi is correct. just a small change.

IF(len(trim(BookDate))=0, Year(InvoiceDate), Year(BookDate)) As BookActionYear;