Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
G3S
Creator III
Creator III

Loading a section of script from a file

hi,

There is a section of script which is used for calculation of a ratio (loads data, has 2 different group by and then calculates final output). It is used in multiple apps. Any modification to this piece of script means it has to be updated in all of the apps it is used in (potentially one or two might be missed).

Is there a way to have this script in an external file and load from there ? 
if not, is there a different idea to keep & load this script from a central place and not have to update the multiple apps? 

Thanks,

Labels (4)
1 Solution

Accepted Solutions
marcus_sommer

You may centralize redundant scripts with variables: Include | Qlik Cloud Help.

Further by using a multi-tier data-architecture you may avoid the redundance itself. This means implementing n hierarchically and/or parallel generator-layers which are loading the raw-data and applying the various transformation step by step and storing each intermediate state in qvd's which are then the source for the next layer.

Of course, such approach will add some overhead but by larger projects and/or bigger data-sets they are indispensable - nevertheless the required efforts and the getting benefit needs to be balanced in regard to the practical widths and depths. 

View solution in original post

2 Replies
marcus_sommer

You may centralize redundant scripts with variables: Include | Qlik Cloud Help.

Further by using a multi-tier data-architecture you may avoid the redundance itself. This means implementing n hierarchically and/or parallel generator-layers which are loading the raw-data and applying the various transformation step by step and storing each intermediate state in qvd's which are then the source for the next layer.

Of course, such approach will add some overhead but by larger projects and/or bigger data-sets they are indispensable - nevertheless the required efforts and the getting benefit needs to be balanced in regard to the practical widths and depths. 

G3S
Creator III
Creator III
Author

Thank you @marcus_sommer will look into both options.