Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
Thank you @marcus_sommer will look into both options.