Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Previous Data load in Script

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.
DateDate_KEYCCY_RATE
31/12/201131/12/201189.9457
1/1/20121/1/2012
2/1/20122/1/2012
3/1/20123/1/201290.1315
4/1/20124/1/201290.2564
5/1/20125/1/2012
6/1/20126/1/2012
31/12/201131/12/201189.9457
1/1/20121/1/201289.9457
2/1/20122/1/2012
3/1/20123/1/201290.1315
4/1/20124/1/201290.2564
5/1/20125/1/201290.2564
6/1/20126/1/2012
31/12/201131/12/201189.9457
1/1/20121/1/201289.9457
2/1/20122/1/201289.9457
3/1/20123/1/201290.1315
4/1/20124/1/201290.2564
5/1/20125/1/201290.2564
6/1/20126/1/201290.2564
Regards,
Zain.
3 Replies
Highlighted
Creator II
Creator II

Hi All,

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

Highlighted
MVP
MVP

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;

Highlighted
Partner
Partner

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