Macros to Create the Folder Dynamically

nikithaj — Tue, 26 Jun 2018 02:24:52 GMT

Hi Everyone,

I have Folder structure something like below:

Sales_Overall_Performance_report

NTUSER1- All_region_access_Reports

NTUSER2- Region_1 Access

NTUSER3- Region_2 Access

Sales_Regionwise_Performance_Reports

NTUSER1- Region1_Access

The requirement is the Folders "Sales_Overall_Performance_report "and "Sales_Regionwise_Performance_Reports" are the Static folders,So I need the Macro Code to dynamically create the Folders(NTUSER1,NTUSER2,NTUSER3) under the Respective Static folders.

Also I have the static Reports created in my Qlikview Applications and Section access is used based on the NTNAME.

Now the Reports that has been created should distribute to the Respective Subfolders based on their access,Suppose the

NTUSER1 has has all access then all the reports should be created in PDF format and should be placed under the NTUSER1 Folder.Similarly if NTUSER2 has access only for Region1 then the PDF report of Region1 only has to be placed in NTUSER2 folder.

We are not using NTPRINTING and nor the QlikviewPublisher.

We are just utilizing the Native Qlikview Reporting and the above requirement has to be achieved through MACROS.

Kindly Suggest on the Same.

Regards,

Nikitha Jain M B

topic Macros to Create the Folder Dynamically in QlikView

Macros to Create the Folder Dynamically