Using a variable to create a QVD file name

[#1]

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!

[#2 · Accepted solution]

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

STORE

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