topic Re: How to share master items between applications ? in App Development

How to share master items between applications ?

jfdierckx — Tue, 08 Sep 2015 07:22:32 GMT

The Master Item feature in Qlik Sense allows you to define complex expressions (including Set Analysis calculations for instance) as reusable measures for the end-users.

Currently, the Master Items are defined at application level, and hence, can be shared within the application.

What would be the best way to share these master item definitions between different applications ?

Re: How to share master items between applications ?

ogster1974 — Tue, 08 Sep 2015 08:32:09 GMT

My guess would be to build an App that is the base data model to test your data quality and build your master item list. Not sure you can import master items programmatically yet but would be a nice feature.

I guess we have to copy them in the old fashioned way

Until we can use Master Items directly in our expressions they are a bit of an overhead to be honest except when managing common visualisations e.g. Calendars that can appear on every sheet.

Regards

Andy

Re: How to share master items between applications ?

JonnyPoole — Tue, 08 Sep 2015 16:55:03 GMT

One old fashioned way that IS dynamic and was considered a best practice is to use variables to store the expressions in a spreadsheet for example.

You can blend this approach with master items by using the variable expression as the DEFINITION of the master item

Step1: Write out your expression in an excel spreadhsheet using syntactically correct Qlik Sense expression

Step2: load the expression into ONE OR MORE Qlik Sense apps using the load editor

in this example, i load only the 'Regions' master item from the spreadsheet. The expression is stored in the variable 'vRegions'

Step3: Create a new master item with the same name as the loaded expression.

Now, if ever you want to change the defintion of the 'Regions' master item. Just change the expression in the spreadsheet and reload all the apps ... one place to change everything. Works for Dimensions and Measures

Re: How to share master items between applications ?

Alexander_Thor — Tue, 08 Sep 2015 18:46:36 GMT

You can import master items, measures and dimensions using the APIs.

I manage my measures in a excel spreadsheet for example and just import them using the APIs.

It's fairly custom as I also specify my main fact field to generate the standard date calculations, YTD/MTD etc etc
But you could most likely simplify quite a bit if you just want to share the definition across apps.

Re: How to share master items between applications ?

simondachstr — Thu, 10 Mar 2016 19:31:40 GMT

I don't recommend this path as it's not easy to see the underlying expression of the variable by double-clicking on it, as you can do on the Master Item list.

Re: How to share master items between applications ?

jfdierckx — Fri, 03 Jun 2016 08:30:36 GMT

Is there a tool available somewhere that would use the API to manage the master items in a central way ?

Re: How to share master items between applications ?

simondachstr — Mon, 06 Jun 2016 08:55:39 GMT

I am sure akl‌ will be happy to share his example of importing measures from Excel. Maybe on branch?

Re: How to share master items between applications ?

Anonymous — Thu, 25 May 2017 07:11:01 GMT

Hi!

could you post an example please??

thanks!!

Re: How to share master items between applications ?

JonnyPoole — Thu, 25 May 2017 14:00:14 GMT

This project will allow for sharing of master items from a central external repository.

Home - EA Powertools Governed Metrics Service

Re: How to share master items between applications ?

adriennn — Tue, 11 Dec 2018 12:12:02 GMT

Hello,
we've release an extension for this purpose, which is lightweight in comparison to the EA Powertools: MasterConfig see our blog post on the matter.
-adrien

Re: How to share master items between applications ?

maxwell_marchand — Wed, 06 Feb 2019 19:24:07 GMT

There is no native way to do this in Qlik Sense yet,

However have recently created a tool that helps you do this by saving Master Items in an excel file. If you're interested check out our Master Item Manager extension on Qlik Branch.

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Introducing-The-GINQO-Master-Item-Manager/ta-p/1533495

https://developer.qlik.com/garden/5c3d224d30f9e70010a8e7be

Re: How to share master items between applications ?

max31 — Mon, 25 Nov 2019 12:39:07 GMT

Hi @JonnyPoole

You gave an example on how to create a variable from a dimension.

How would you load all rows of the Excel file at the same time? (and not just 'Regions')

Thanks for your help.

Max

Re: How to share master items between applications ?

rogeriogyn — Sat, 07 Mar 2020 14:13:35 GMT

You can use qdevops command from https://github.com/rogerio-faria/qdevops

So you can schedule these commands. Example:

1 - Export the master measures to a file

qdevops -u=node1.txt -m=export,xxxx-x-x-xxx-xxxxx-xx,metrics.txt

2 - Once, measures are stores in vars.txt, just import to the other app (may be other server), you can use a .bat file

qdevops -u=node1.txt -m=import,yyyy-y--yyyy-yyyyyy,metrics.txt
qdevops -u=node2.txt -m=import,2222-22222-222-2222,metrics.txt
qdevops -u=node2.txt -m=import,3333-3333-3333-3333,metrics.txt

Re: How to share master items between applications ?

bugsysiegals — Thu, 18 Jun 2020 01:27:05 GMT

I currently have 150 Master Items of KPI's which have similar but slightly different set analysis per region. A simple find/replace would allow me to updates them as needs change within minutes; however, I'm currently doing this manually in 5+ hours. I'm happy to find this post and wonder if I export the Master Items, modify the file with find/replace, can I import them back into the same application and overwrite the existing Master Items for my purpose?

Re: How to share master items between applications ?

maxwell_marchand — Thu, 18 Jun 2020 01:32:54 GMT

Hey there, thanks for your inquiry. Yes you definitely can Export the
Master Items, add them to the template file, and re-import them back into
your application!
Just note that he process you are describing may require some slight
modification for the exported Master Items once they are in your template
file

Let me know if you have any additional questions!