topic Re: Previous Data load in Script in QlikView

Previous Data load in Script

Tue, 04 Sep 2012 12:51:20 GMT

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.

Re: Previous Data load in Script

qlikviewforum — Thu, 07 Aug 2014 13:46:32 GMT

Hi All,

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

Re: Previous Data load in Script

maxgro — Thu, 07 Aug 2014 13:56:27 GMT

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;

Re: Previous Data load in Script

crusader_ — Thu, 07 Aug 2014 14:00:30 GMT

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