GINQO Master Item Manager

Our intention at GINQO was to create an application that would help most with efficiency in development, especially around Master Items. Since Master Items are frequently reused across applications, and the process for creating them is a slow and manual one, we felt a governed approach would fit best.

Using our template file, Master Items can be saved in excel for load and creation in Qlik Sense. Master Items can then be selected from a Qlik table, previewed (in batch), then syncronized or deleted using The Master Item Manager tool. Finally, by default, the application won't affect your manually created Master Items unless you first export them into the template file, making it a safe tool to use with in conjunction with previously defined apps & master items.

Prerequisites

Qlik Sense Enterprise >= November 2022
Qlik Cloud >= November 2022
Qlik Sense Desktop >= November 2022

Installation

Download this extension on a zip file using the 'Clone or Download' button (or select from an individual release)
Navigate to the 'Extensions' directory under the Qlik Management Console (QMC)
Import the zip file (note: you can only have version of the Master Item Manager imported at any given time, so you may need to delete the old version when reimporting)

Getting Started

Navigate to the Data Load Editor
Create a Data Connection to your own copy of the template excel file (a copy provided for you in the zip file), dropbox and box.com both work well for this step
Insert the scripts for your Dimensions and Measures tables (you can add REPLACE LOADs if you want to enable partial reloads for larger applications)
Back in your Qlik Sense Application, create one table for the template file's Dimensions and another for template file's Measures (Highly recommend qsQuickTableViewer from ChristofSchwarz and Ralf Becher for this https://github.com/ChristofSchwarz/qsQuickTableViewer)
You can now use the Master Item Manager to create your Dimensions and Measures from the provided template file.

Simple Script Example

Set HidePrefix = '%';		// Hide prefix to hide Master Item Manager selections from UI

[Dimensions]:
REPLACE LOAD			// Replace Load to allow for partial reloads (slims down the reload time)
	[%MI%DimensionField],
	[%MI%DimensionName],
	[%MI%DimensionLabelExpression],
	[%MI%DimensionDescription],
	[%MI%DimensionColor],
	[%MI%DimensionTags],
	[%MI%DimensionId]
 FROM [lib://AttachedFiles/Master Item Manager.xlsx]
(ooxml, embedded labels, table is Dimensions);

[Measures]:
REPLACE LOAD
	[%MI%MeasureExpression],
	[%MI%MeasureName],
	[%MI%MeasureLabelExpression],
	[%MI%MeasureDescription],
	[%MI%MeasureColor],
	[%MI%MeasureTags],
	[%MI%MeasureSegmentColor], // optional
	[%MI%MeasureSegmentColorFormat], // optional
	[%MI%MeasureFormatType], // optional
	[%MI%MeasureFormatFmt],	// optional
	[%MI%MeasureFormatDec],	// optional
	[%MI%MeasureFormatThou],// optional
	[%MI%MeasureId]
 FROM [lib://AttachedFiles/Master Item Manager.xlsx]
(ooxml, embedded labels, table is Measures);

Using the Template file

Dimensions and Measures must have unique ID's
Remember to prefex any = (equals) signs with a '(single-quote) when using excel. This will prevent excel interpretting your Qlik expression as an excel function.
It is recommended that calculated expressions (usually label expressions) are wrapped in quotes: EG: '='Sum(Dim1)'
It is recommended that text based expressions (usually label expressions) are wrapped in quotes: ''Label Expression Example'
Measures required: Expression, Name
Dimensions required: Field, Name

Actions

General:

Partial Reload: Using REPLACE LOADs in your load script will allow you to leverage this functionality to pull new Dimension/Measure schemas without running a large applications load.
Info/Help: Shows instructions for how to use the GINQO Master Item Manager

Editing Dimensions:

Syncronize: Creates and Updates Dimensions according to your template and selections
Delete: Deletes Dimensions according to your template and selections (requires dimensionID)
Delete All: Deletes ALL Dimensions in the application (warning: this applies also to metrics not defined through your template file)
Export: Will export a template list composite of your Dimension Master Items existing in the app
Validate: Shows which Dimensions your actions (synchronize/delete) will affect

Editing Measures:

Syncronize: Creates and Updates Measures according to your template and selections
Delete: Deletes Measures according to your template and selections (requires measureID)
Delete All: Deletes ALL Measures in the application (warning: this applies also to metrics not defined through your template file)
Export: Will export a template list composite of your Measure Master Items existing in the app
Validate: Shows which Measures your actions (synchronize/delete) will affect

Authors

Maxwell Marchand - Product Lead and Founder
Riki Suharda - Developer

Change Log

2019-12-17: Combined update and create functionality into syncronize option
2019-12-17: Added preview section after syncronizing to show which Dimensions and Measures will be created
2019-12-17: Added December 2019 release
2022-06-01: Custom format number is now supported
2020-06-01: Improved maintainability and overall performance for large imports. Improved schema handling.
2022-06-01: Measure segment colors are now exportable and importable in this version
2022-06-01: Dimension value colors are now exportable and importable in this version
2022-06-01: QlikCloud is now supported (Tested version: Februrary 2022)
2022-06-01: Some enhancements in layout and embedded images
2022-09-06: Fixes for media image links (.tff and .woff) display incorrect on Qlik Sense Enterprise
2022-12-21: Major updates on js code for handling missing columns in config file
2022-12-21: Fixed the master item preview that was not displaying correctly due to a missing config column
2023-10-23: Fix the configuration to manage the custom number format for measures through the config file. Note that the existing measure number format will stay if the custom format is not configured in the config file.
2023-10-23: Improve code readability and fix some script logic
2023-10-23: Added more samples to the config file

Known Issues and Limitations

- Complex drilldown dimension expression is not supported.
- Editing a "base" Master Item that other Master Items call will break all objects reusing it.
  Workaround: Manually save the modified measure: Right-click -> edit the Base item, save it
- Delimiting for Comma Separation has not been completely handled. Complex cases of expressions might be parsed into multiple excel columns

GINQO/Master-Item-Manager