Adding to Master Items from Data Load

[pgrenier]

Good morning,

I very much like this new approach of having access to Master Items for ease of reuse during app development in Qlik Sense. Like many, I am a great fan of creating variables in order to store complex expressions, or even simple ones, thus simplifying their reuse within a QlikView document.

Knowing this, one might understand that I currently use a sort of externally maintained expression library that gets loaded as variables at the same time the document's data gets refreshed. So, loading expressions into variables, I've pretty much got that covered, and I'm also quite sure I could reuse the same approach in Sense.

But now, knowing that this Master Items feature exists, I am curious to figure out how I could transform my current approach into "automagically" creating Master Items rather than a bunch of variable. Any ideas?

Thanks in advance for your time, regards,

Philippe

[#2]

I am also very interested in knowing if there is an "automagical" way of doing this. For now I have not found a way of doing this on the actual Qlik Sense release.

[Michael_Tarallo]

Hi Guys - yes you can do this with the Master Items list, but keep in mind a few things:

• Master Items (Dimensions, Measures, configured visualizations)  - expressions configured in this way - are just for a specific app
• Currently "expressions" and the name given to them defined in Master Items CANNOT be referenced in another defined Measure / Dimension. This will improve over time.

Using the Load Script to define your variables and expressions, in certain cases, may be the better option.

Let me know if you have any follow  up questions, and please remember to mark the question appropriately so our teams and other community members know that they have been answered to your satisfactions.

Regards,

Mike

[pgrenier]

Thanks for you reply Michael,

So, as I understand it, there is no way to achieve the definition of Master Items from the Data Load.

I guess we'll have to wait for a later release, then.

Cheers,

Philippe

[Michael_Tarallo · Accepted solution]

Hi Philippe,

Correct - using the Data Load Editor - this will not populate the Master Items list .... however you could use the API to do so. (I have learned this recently as I have gained more knowledge in this area.)

We have a host of APIs that can automate many manual tasks. The Qlik Engine API has a "Generic Object Definition" - where you can define what we call a "hypercube" using a number of methods. You would define these in a standard JSON structure. There is an example in the Sense platform documentation that customers will be able to view once the product is GA later this month.

So in general, this API will allow you to populate the Master Items list "auto-magically"

Mike

[Michael_Tarallo]

Here is a screen shot of the documentation from the on-line help site that will be available:

[NareshGuntur]

Hi Mike,

Is there an option where we can categorize/custom sort the measures and visualizations so that it avoids confusion to the users while using if there are too many.

Cheers,

Naresh

[Michael_Tarallo]

Hi Naresh,

There is something that is in development and you can take a look at it here:

http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Scripting/fields.htm

Currently, it just categorizes the Date / Time fields. - Derive and Declare are two keywords that are used.

Calendar:

DECLARE FIELD DEFINITION TAGGED '$date'

   Parameters

      first_month_of_year = 1

   Fields

      Year($1) As Year Tagged '$year',

      Month($1) as Month Tagged '$month',

      Date($1) as Date Tagged ('$date', '$day'),

      Week($1) as Week Tagged '$week',

      Weekday($1) as Weekday Tagged '$weekday',

      DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

DERIVE FIELDS FROM EXPLICIT TAGS '$date' USING Calendar;

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[NareshGuntur]

Hi Mike,

Thanks for the response.

I missed this until you mentioned. However, I am looking at the visualizations and the measures but not at the field level.

Cheers,

Naresh

[Michael_Tarallo]

Hi Naresh,

I thought so - but wasn't sure - at this time - there isn't any plans on grouping or categorizing these, but I will add this to the ideation meeting. Perhaps it may be in there too.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik