topic Re: Reduce and Distribute to different folder in QlikView

Reduce and Distribute to different folder

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

Hi ,

I need to reduce a single application into 3 applications and distribute to 3 folders .

for eg:

i have a application contains data's of 3 country's (INDIA, US , CANADA) . now i need to distribute each country's data into 3 folders. so that the application will have the same name but 3 different data.

could any one help me out with this requirement .

Re: Reduce and Distribute to different folder

PrashantSangle — Fri, 18 Sep 2015 05:18:50 GMT

Hi,

you can reduce it in where clause

try like

India:

Load *

from TableName

where Country='India';

Store India into ../India/app.qvd;

Drop table India;

US:

Load *

from TableName

where Country='US';

Store India into ../US/app.qvd;

Drop table US;

Regards

Re: Reduce and Distribute to different folder

elakkians — Fri, 18 Sep 2015 05:22:12 GMT

i am not looking to store the data i am using publisher to distribute the application .

Re: Reduce and Distribute to different folder

sunilkumarqv — Fri, 18 Sep 2015 05:24:14 GMT

http://www.qlik.com/us/videos/landing-pages/security-video-series/security-video-series-pt5

Re: Reduce and Distribute to different folder

elakkians — Fri, 18 Sep 2015 05:30:12 GMT

this video shows how to distribute to the same folder with different names .

my requirement is to distribute to different folders but same name .

Re: Reduce and Distribute to different folder

Bill_Britt — Fri, 18 Sep 2015 14:58:08 GMT

HI,

You can do this with publisher, but it will require three task to do it. Each task would do the distribution to a different folder

Bill

Re: Reduce and Distribute to different folder

Anonymous — Fri, 18 Sep 2015 15:12:59 GMT

HI,

Maybe Create the new fields(for each value of country) on the data model ,

Next create different tasks in QMC to distribute the files into different folders.

Regards

Neetha

Re: Reduce and Distribute to different folder

elakkians — Tue, 22 Sep 2015 10:04:32 GMT

here is a way to get this working by using only one Task.

- Manage the Foldernames as a DocumentField in the Data Model

- Reduce by Field Foldername with a Publisher Task. Reduced Document Name is something like :

%DocumentField,Foldername%\%SourceDocumentName% %DocumentField,Foldername%

- Distribute PDF or qvw to a Folder that contains all Foldernames of the DocumentField as subfolders

That is all.