currency script

Fri, 14 Jun 2013 12:23:04 GMT

Hello

i am using qlikview 11.

i have got currency script from forum but this scrpt is working for current day ony

I.e if script is not reloaded for 2 days then currency rate of that days is not comming in qvd.

anybody have any solution so that currency rate of prevoius days will come in qvd.

i am posting my script here

pls help

T_LastDate:

LOAD

Max([End Date]) As MaxExchangeDate From HisCurrency.qvd (qvd);

Let zMaxExchangeDate = Peek(MaxExchangeDate);

DROP Table T_LastDate;

For zi = $(zMaxExchangeDate)+ 1 to Today()

Let dd = Date(zi, 'YYYY/MM/DD');

HisCurrency:

LOAD

Date(Today(),'YYYY/MM/DD') As [End Date],

[Units/1 USD] as [USD/KES],

[Units/1 USD] ,

Year(Today()) As Year,

Month(Today()) As Month,

Day(Today()) As Day,

Week(Today()) As Week,

WeekYear(Today()) & '-' & Num(Week(Today()),'00') As RollingWeek,

Weekday(Today()) As WeekDay,

Date(MonthStart(Today()),'YYYY-MM') As RollingMonth,

Right(year(Today()),2) & '-Q' & ceil(Month(Today())/3) as [YearQtr],

'Q' & Ceil(Month(Today())/3) As Quarter

(html, codepage is 1252, embedded labels, table is @1);

Next zi

Concatenate (HisCurrency)

LOAD * From HisCurrency.qvd (qvd)

Where Not(Exists([End Date]));

Store HisCurrency into 'E:\Currency\HisCurrency.QVD';

topic currency script in QlikView