topic Re: Load qvd automatically based on day basis in QlikView

Load qvd automatically based on day basis

Mon, 17 Jun 2013 06:31:16 GMT

Hi,

I am storing a qvd everyday in a folder from Monday to Friday.

My requirement is I would like to use the qvd on day basis for instance today is monday, so the report has to load the Moday.qvd automatically if the day is Tuesday means it has to load the Tuesday.qvd in the report.

Currently as I am using for each day a report, that is taking more space, so I need to avoid this.

Thanks in advance

Regards

Chriss

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 06:36:50 GMT

try according to this

Temp:

LOAD * from table;

LET vDay = Date(Today(),'wwww');

STORE Temp into D:\$(vDay).qvd;

Re: Load qvd automatically based on day basis

Anonymous — Mon, 17 Jun 2013 06:57:09 GMT

Can you make it more clear why is you daily create a new qvd?

why not in on transaction table?

please make it more clear...

Regards,

anant

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 10:27:26 GMT

Hi Vishwa,

Thanks for your reply

I tried what you said but I can not get the solution, there is a specific foler the 5 days qvd will be stored, if today is monday means the script should load automatically Monday.qvd as the same for the rest of days.

Regards

Chriss

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 10:46:49 GMT

your script should load automatically, then you must make Batch file and then by the use of task schedular you can run your script automatically by the use of my previous posted code.

Regards

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:04:07 GMT

You can try like this...

IF WeekDay(Today()) = 'Mon' Then

LET vQVDPath = 'D:\Mon\';

ELSEIF WeekDay(Today()) = 'Tue'

LET vQVDPath = 'D:\Tue\';

ELSEIF WeekDay(Today()) = 'Wed'

LET vQVDPath = 'D:\Wed\';

ELSE

LET vQVDPath = 'D:\Thu\';

TableName:

LOAD Field1,Field2 From '$(vQVDPath)'\filename.qvd;

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:09:05 GMT

Hi Viswarajan,

Hope I am not clear to you.

I have already created a QVD in a folder from Monday to Friday that is I have now 5 QVD's in the name of

Monday.qvd, Tuesday.qvd.

Now I am trying to load the if today() is Monday means the script has to load Monday.qvd, suppose if today() is Tuesday means Tuesday.qvd has to reload.

Hope its clear...

Regards

Chriss

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:26:06 GMT

write your qvds according to this.

IF Date(Today(),'wwww')='Monday' then

load * From table1;

store tabl1 into D:\Monday.qvd;

ELSEIF Date(Today(),'wwww')='Tuesday' then

load * From table2;

store tabl2 into D:\Tuesday.qvd;

ELSEIF Date(Today(),'wwww')='Wednesday' then

load * From table3;

store table3 into D:\Wednesday.qvd;

ELSEIF Date(Today(),'wwww')='Thursday' then

load * From table4;

store table4 into D:\Thursday.qvd;

ELSEIF Date(Today(),'wwww')='Friday' then

load * From table5;

store table5 into D:\Friday.qvd;

ELSE

EXIT Script;

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:27:16 GMT

Did you try this?

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:42:38 GMT

If I understand it correct, then he has already the QVD-s, he just wants to load from the right QVD on the right weekday.

Smth like this:

IF Date(Today(),'wwww')='Monday' then

load * D:\Monday.qvd;

ELSEIF Date(Today(),'wwww')='Tuesday' then

load * D:\Tuesday.qvd;

*****************

ELSEIF Date(Today(),'wwww')='Friday' then

load * From D:\Friday.qvd;

ELSE

EXIT Script;

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:43:20 GMT

Hello Karthik,

Yes, its working fine as what I expected ..... and Thanks to Vishwa also for your support.

Regards

Chriss

Re: Load qvd automatically based on day basis

Mon, 17 Jun 2013 11:48:35 GMT

what you can do is to set a variable contening path/file.qvd based on the day to avoid if...then

LET fich=weekday(today()) & 'day.qvd';

today , it will give monday

LOAD

from $(fich);

best regards

chris