Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nikithaj
New Contributor

Macros to Create the Folder Dynamically

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