Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sharing load scripts with multiple reports

Environment QV 8.5

I have inherited the maint and development of QV reports at my organization.

Many of the reports use almost identical map loads from .qvd files.

Is it possible to have each reports load script call a mapping load file so that the mapping code does not have to be replicated in each report?

Thanks

Example of map loads used in each report:

HierarchyMap:

mapping LOAD

trim(text(%xxxxxxx)),

[Customer Name]

FROM C:\SAP_Qlikview\QVD_PROD\General_Data_in_Customer_Master.qvd (qvd);

ProductHierarchyMap:

Mapping Load

trim(text(xxxxxx)),

VTEXT

FROM C:\SAP_Qlikview\QVD_PROD\Material_Hierarchies.qvd (qvd);

DivisionMap:

Mapping LOAD

trim(text(%xxxxxxx)),

[Division - Code & Name]

FROM C:\SAP_Qlikview\QVD_PROD\Division_Desc.qvd (qvd);

SalesOrgMap:

mapping LOAD

trim(text(%xxxxx)),

[Sales Org. - Code & Name]

FROM C:\SAP_Qlikview\QVD_PROD\SalesOrg_Desc.qvd (qvd);

DisChanMap:

mapping LOAD

trim(text(%xxxxxxxxxx)),

[Distribution Channel - Code & Name]

FROM C:\SAP_Qlikview\QVD_PROD\Distribution_Channel_Desc.qvd (qvd);



1 Reply
Not applicable
Author

Hi,

Yes, you can have a separate text file and call the script using "Include" function in the script.

Eg:

$(Include=c:\development\peace dshboard\source\peasesummaryconfiguration.txt)

My understanding of Report means individual QVW file.