Discussion Board for collaboration related to QlikView App Development.
I am also looking for the same. Any update from anyone on this?
Date, Date_KEY, CCY_RATE
FROM [http://community.qlik.com/thread/60912] (html, codepage is 1252, embedded labels, table is @1)
where RecNo()<=7 ;
Date, Date_KEY, CCY_RATE,
if(len(trim(CCY_RATE))=0, peek(NEW_CCY_RATE), CCY_RATE) as NEW_CCY_RATE
order by Date;
DROP Table tmp;
LOAD * INLINE [
Date, key, rate
01.02.2014, 1, 23.44
01.05.2014, 4, 21.33
01.06.2014, 5, 20.111
if(isnull(rate) or rate='', peek(rate),rate) as rate
drop table tst;
Is it necessary to give new alias?