topic Distribute to dynamic folder in QlikView

Distribute to dynamic folder

JanFloren — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I'm currently having the following problem. I have a QVW application where I use the loop and reduce functionality to split it up into 20 different QVW's... each file containing the data for one country.

Now I have a folder structure with seperate folders for every country, so the idea is that the QVW containing Germany's data ends up in the folder "Germany" and the one containing data from Francen in the folder France etc

Anyone knows how this can be done in a single task ? ... I think it was possible in earlier versions, but can't seem to find a working solution now.

Thanks for the help.

Regards,

Jan

Distribute to dynamic folder

danielrozental — Mon, 14 May 2012 14:04:24 GMT

Can you do something like %DocumentField,F1%\%SourceDocumentName%_%DocumentField,F1% in the reduced document name?

Take the folder name from a field in the document and use it in the loop & reduce settings.

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 11:10:08 GMT

I have the same problem. And it does not help. All files saves into one folder with name "%DocumentField,F1%". How i can save files into dynamic folders named as values of field?

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 11:35:03 GMT

I'm storing all files in same folder, but change the file name depending on the variables Year and j (counter for week)

Like this:

SET FileNamePer= '$(vFolderMainPath)$(vFolderSourcePerData)$(Year)_$(j).qvd';

Store PerData into $(FileNamePer) (qvd);

Should work similar if you'd like to store it into a different Folder

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 12:08:52 GMT

I want to do this without changes in load script and without reloading of data. Such as QV Publisher reducing. Is there another way?

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 12:13:00 GMT

It can be done.

You just to have your reduction on field in place and it works.

And the result will be

Each contains a reduced qvw.

Re: Distribute to dynamic folder

lft — Thu, 12 Sep 2013 12:17:42 GMT

Hi,

If the trick with the file name doesn't make it, you could call a supporting task chained with your distributing task. This ST would make a call to an external program (like a .bat) that would move all the QVWs into the right folder based on the QVW file name.

Regards,

Loic

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 12:45:10 GMT

Thanks! It seems good. But i have no results doing all such way. Which version of QV you are using? I am using QV 11.

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 12:52:23 GMT

You should have publisher to do so!

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 13:03:16 GMT

Yes, of course. I try to do it in QV Publisher.

Re: Distribute to dynamic folder

Thu, 12 Sep 2013 13:14:50 GMT

Thanks, it is a good way! And i try to make such .bat file if if I can not find solutions with the help of QlikView.