article Creating Dimensions and Measures in Qlik Sense Documents

Creating Dimensions and Measures

Jennell_Yorkman — Fri, 26 Jun 2015 19:24:57 GMT

One of my favorite features of Qlik Sense is the ability to create and reuse Master Items. Master Items are dimensions, measures and visualizations that have been saved in the Asset panel in a Qlik Sense app. In the attached document I describe how dimensions and measures can be created in Qlik Sense.

Also check out my blog on Master Items.

Jennell

Re: Creating Dimensions and Measures

hugmarcel — Tue, 18 Aug 2015 09:29:59 GMT

Thank you Jennell for this.

What I am definitely missing is the possibility to create master items within QSense Script. Your possibilities all need manual work. This is not feasible if KPIs, dimensions etc. are already defined in e.g. an XLS file for QlikView.

Regards - Marcel

Re: Creating Dimensions and Measures

Tue, 25 Aug 2015 07:07:05 GMT

Is there a way to tag your fields with dimensions and measures in a QVD file, like in QlikView:

/* To indicate to QlikView that fields are dimensions */

TAG FIELDS field1, field2 WITH $dimension;

/* To indicate to QlikView that fields are measures */

TAG FIELDS field3, field, 4 WITH $measure;

This is working in QlikView, but as far as I can see, not in Sense. Am I doing something wrong?

Re: Creating Dimensions and Measures

hugmarcel — Tue, 25 Aug 2015 08:42:22 GMT

I think the tags cannot be used to create master items. Check

New IDEA: Create master items (dimensions, measures) in script

Regards - Marcel

Re: Creating Dimensions and Measures

nickedw0 — Thu, 18 Mar 2021 17:03:23 GMT

What is the benefit of creating dimensions from fields, when fields can also be inserted into tables as dimensions.