Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Jennell_McIntire
Employee
Employee

One of my favorite features of Qlik Sense is the ability to create and reuse Master Items.  Master Items (seen in the image on the left) are dimensions, measures and visualizations that have been saved in the Asset panel in a Qlik Sense app.  During the development process, Master Items can be used to create visualizations and once the app is published, the Master Items are available in the Library panel (seen in the image on the right) for others to use.

MasterItems.png                                                       Library.png

When creating apps, it is common to use the same dimensions and/or measure in more than one chart – that is why Master Items are so useful.  I can create a Master Item measure such as Sales (Sum([Sales Amount])) and then use this measure in multiple charts.  I do not need to copy and paste the measure every time I need to use it.  All I need to do is drag it to my chart or select it from the list of measures.  If I decide that I need to make a change to the measure, all I have to do is edit the measure in the Master Items and the change will be made anywhere the measure is used.  This saves time and keeps the app/measures consistent.  The same can be done with dimensions that are used often in an app.  Create it once and use it wherever needed.  The Asset panel also has an area for visualizations that can be created by the developer and saved giving users the ability to drag a pre-made visualization to their sheet.  In this blog, I will focus on the dimensions and measures section of the Master Items.

There are a few ways you can create a Master Item.  Let’s first take a look at how you can create a dimension.  There are three ways you can create a dimension.

  1. From the Fields section in the Asset panel
  2. From the Master Items section in the Asset panel
  3. From the Data Model Viewer

For a closer look at how to create dimension, check out this documentCreating Dimensions and Measures.

Measure can be created in a similar way as the dimensions.

  1. From the Fields section in the Asset panel
  2. From the Master Items section in the Asset panel
  3. From the Data Model Viewer

For a closer look at how to create measures, check out this documentCreating Dimensions and Measures.

Once the dimensions and measures are created, they can be used to create visualizations.  When you are prompted to add a dimension or a measure to a chart, the dimensions and measures that were added to the Master Items will be listed first.

Here is what you see when prompted to add a dimension:

AddDimension.png

Here is what you see when prompted to add a measure:

AddMeasure.png

You can simply select the dimension/measure or you can drag the dimension/measure from the Master Items section to the chart.

Dragging Customer dimension to a bar chart:

DragDimension.png

Dragging Sales measure to a bar chart:

DragMeasure.png

If you find the need to edit or change a dimension and/or measure, you can make the change in the Edit window and save.  This change will be applied to all charts using the dimension and/or measure.  So no more copying and pasting a measure change to all charts using the measure.  This also ensures that the dimension and/or measure is updated consistently throughout the app.

Once the app is published, users can make use of the dimensions and measures in the Library to build their own visualizations or to edit existing visualizations.  The user can drag and drop the dimensions and measures onto their charts and they do not need to worry about the expression or syntax because it is already done for them.

As you can hopefully see, it is very easy to add dimensions and measures to the Master Items and by taking the time to do so before creating your charts will prove to be quite valuable.  Not only will it save you time when developing because of the reuse capabilities, it will aid you in creating a clean app that is consistent and easy to maintain.  Once the app is published, it provides users self-service capabilities to build their own visualizations.  If you do not create Master Items, I recommend you start.  It is a great feature that in the end makes your job as the developer easier.

Thanks,

Jennell

18 Comments
bgarland
Creator III
Creator III

‌is it possible to hide the Fields tab so that users only have access to the Master Items?

14,283 Views
Patrik_Lundblad
Employee
Employee

Hi Brian,

In an app published on a server the user will see the top right screenshot. In it they don't have access to the fields tab.

0 Likes
14,283 Views
Not applicable

Hi Brian,

You can also use the hideprefix variable in every column of your model while executing your script load as a workaround, but you will have to declare every Dimension/Measure the user requires in order to him to create charts.

Ryuma.

0 Likes
14,283 Views
cesaraccardi
Specialist
Specialist

Hi,

Is it possible to control which Master Items are available to users?

0 Likes
14,283 Views
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

One more feature that I will like to be added to Master item is security, Who can see and use different items in Master Item. Be it Dimension, Measure or Visualization. As things are (although I might be wrong) all users who have access to the .qvw file can use and see Master Items.

To be honest Master Item is powerful feature in Qlik Sense for both developer and users.

0 Likes
14,283 Views
NareshGuntur
Partner - Specialist
Partner - Specialist

Is there a way where we can categorize the visualizations/metrics so that it will be easier for the user to use.

I see these are alphabetically sorted in ascending order. At-least custom sort can help.

0 Likes
14,283 Views
hugo_andrade
Partner - Creator II
Partner - Creator II

You can adopt a naming convention to facilitate the usage of the Master Items. It may end up with longer names, but there are no complaints where it is in place for us.

0 Likes
11,119 Views
ali_hijazi
Partner - Master
Partner - Master

what is the difference between measures in Master Items and variables? aren't they the same?

I mean if I use a variable called vSales defined as Sum(Sales) then if I modify it once it will apply to wherever it is used

0 Likes
11,119 Views
Jennell_McIntire
Employee
Employee

Hi Ali,

That is correct but if you add the measure to the Master Items, you can easily drag and drop it to your charts.

Jennell

0 Likes
11,119 Views
ali_hijazi
Partner - Master
Partner - Master

ok it is for the sake of drag and drop ability

but how do we define master measure? just by naming the field? can't we use set analysis syntax?

please advise

0 Likes
11,119 Views