Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load qvd automatically based on day basis

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

11 Replies
Not applicable
Author

Hello Karthik,

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

Regards

Chriss

Not applicable
Author

Hi

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