Using a variable to create a QVD file name

Thu, 10 Dec 2009 00:48:49 GMT

Hello All,

Is it possible to use a variable to dynamically name QVDs?

I have many months of billing data, each month stored it its own TXT file. I want to load in each file, massage and reformat, then store into a QVD with a filename that describes which month it contains. I am able to get the month from the data and store into a variable, but not sure how I can use that variable to create the filename for the QVD. Any suggestions?

Thanks!

Using a variable to create a QVD file name

Thu, 10 Dec 2009 01:10:58 GMT

I figured it out, turns out its not that hard after all

STORE

Billing INTO C:\Qlikview\Billing_$(MonthYear).qvd;

topic Using a variable to create a QVD file name in QlikView

Using a variable to create a QVD file name

Using a variable to create a QVD file name