Previous Data load in Script

[#1]

Hi,

given below is data available in qlikiview after load in black, i used condition

if(isnul(CCY_RATE), PREVIOUS((CCY_RATE),(CCY_RATE) in script it shows result in green,

my requried result is in yellow.

Date	Date_KEY	CCY_RATE
31/12/2011	31/12/2011	89.9457
1/1/2012	1/1/2012
2/1/2012	2/1/2012
3/1/2012	3/1/2012	90.1315
4/1/2012	4/1/2012	90.2564
5/1/2012	5/1/2012
6/1/2012	6/1/2012
31/12/2011	31/12/2011	89.9457
1/1/2012	1/1/2012	89.9457
2/1/2012	2/1/2012
3/1/2012	3/1/2012	90.1315
4/1/2012	4/1/2012	90.2564
5/1/2012	5/1/2012	90.2564
6/1/2012	6/1/2012
31/12/2011	31/12/2011	89.9457
1/1/2012	1/1/2012	89.9457
2/1/2012	2/1/2012	89.9457
3/1/2012	3/1/2012	90.1315
4/1/2012	4/1/2012	90.2564
5/1/2012	5/1/2012	90.2564
6/1/2012	6/1/2012	90.2564

Regards,

Zain.

[qlikviewforum]

Hi All,

I am also looking for the same. Any update from anyone on this?

[maxgro]

tmp:

LOAD

Date, Date_KEY, CCY_RATE

FROM [http://community.qlik.com/thread/60912] (html, codepage is 1252, embedded labels, table is @1)

where RecNo()<=7 ;

table:

NoConcatenate load

Date, Date_KEY, CCY_RATE,

if(len(trim(CCY_RATE))=0, peek(NEW_CCY_RATE), CCY_RATE) as NEW_CCY_RATE

resident tmp

order by Date;

DROP Table tmp;

[crusader_]

Hi,

tst:

LOAD * INLINE [

  Date, key, rate

  01.02.2014, 1, 23.44

  01.03.2014, 2

  01.04.2014, 3

  01.05.2014, 4, 21.33

  01.06.2014, 5, 20.111

];

NoConcatenate

test:

LOAD

  Date,

  key,

  if(isnull(rate) or rate='', peek(rate),rate) as rate

Resident tst;

drop table tst;

works too.

Is it necessary to give new alias?

Andrei