topic Load qvd based on the variable value in QlikView

Load qvd based on the variable value

Thu, 17 Nov 2011 12:06:03 GMT

Can we load the Qvds for the value in the variable.

for eg: There is a loop where the i value changes and i need the previuos file to be loaded everytime, like my from statement which is as below

FROM "D:\Working\Max"&$(i)-1&".qvd" (qvd);

Thu, 17 Nov 2011 12:30:53 GMT

Yes, you can use variable in QVD name. to only change you must done to the exemple string to work is "D:\Working\Max"&num($(i)-1)&".qvd" (qvd);

Thu, 17 Nov 2011 12:33:06 GMT

Yes, it possible. It goes something like this:

For <>
SET vQvdPath = 'D:\Working\Max'&$(i)-1&'.qvd(qvd)';
Data:
Load * from $(vQvdPath);