Sharing load scripts with multiple reports

Mon, 19 Apr 2010 20:51:13 GMT

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);

Tue, 20 Apr 2010 02:25:17 GMT

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.

topic Sharing load scripts with multiple reports in QlikView