Script reuse

Tue, 06 Sep 2011 22:15:57 GMT

Hey people,

I am trying to build a dashboard which could get the table from some database updated every month. So I have loaded the data of last three month like the chart below:

My script is like

Directory;

LOAD Date,

June AS M1,

July AS M2,

August AS M3

FROM

test1.xls

(biff, embedded labels, table is Sheet1$);

However, the Loading is hard coded. Thus if i want to reload the data table test1 this month, which is updated with information of July, August and Septmber, my reload will fail.

Wondering if there is a way that I can make it work monthly?

Thanks in advance!

Best,

Thomas

Script reuse

fosuzuki — Wed, 07 Sep 2011 17:29:10 GMT

Hi,

for the dynamic months, I think you can use something like this:

let M3 = date(today(), 'MMMM');

let M2 = date(addmonths(today(), -1), 'MMMM');

let M1 = date(addmonths(today(), -2), 'MMMM');

load Date,

$(M3) as M3,

$(M2) as M2,

$(M1) as M1

FROM test1.xls (biff, embedded labels, table is Sheet1$);

Hope this helps you.

Regards,

Fernando

topic Script reuse in QlikView

Script reuse

Script reuse