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