|
Understand the mpmX Master Item and Language Tables |
Scroll Previous Topic Top Next Topic More |
The mpmX Master Item and Language Tables are created from the belonging csv files of the mpmX Template App.
No fields should be removed from the tables, nor should any key fields be changed, so as not to impair the function of the app.
Languages
Field Name |
Explanation |
Languages |
Contains the available languages for the mpmX Template App. |
MasterItems
Master Items originating from the MasterItems.csv-files.
Field Name |
Explanation |
_MasterItemID |
A unique ID for the master item which is used to connect the master items between the front end and back end, to perform updates and to change the properties of a master item. |
_MasterItemLabel |
The label expression which is used by the mpmX Template App to be displayed on the chart axis when using the master item (Qlik Sense® September 2017 or later). |
_MasterItemType |
Either "Measure" for numbers or the "Dimension" for categories. |
_MasterItemName |
The name of the master item, which is displayed in the master items panel. |
_MasterItemExpression1 |
The formula expression for the measure or dimension used by the mpmX Template App. |
_MasterItemTags |
A list of terms that are used to tag the master item. See more. |
_MasterItemColor |
The HEX code to define the color of the master elements, which is in the format "#000000" or null(). |
_MasterItemExpression2-5 |
Additional fields, when required for a drill-down dimension should be added as extra columns using a sequential number in the field title. |
ScenarioFlag |
The scenario-file from which the data was created. |
SourceSystem |
The data source from which the data was created. |
FlagCustom |
A flag, if the master item is created by customization or as default by the mpmX Template App. |
_MasterItemSegementColors |
The colors assigned to specific segments. |
_MasterItemSegmentLimits |
The limits of the segment that a master item has. |
_MasterItemSegmentLimitType |
The type a limit of the segment that a master item has. |
_MasterItemSegmentLimitGradient |
The gradient a limit of the segment that a master item has. |
_MasterItemFormatType |
The format type of a master item. |
_MasterItemFormatPattern |
The pattern that is used for the master item. |
_MasterItemDecSeparator |
The symbol used to separate the integer part from the fractional part of a number written in decimal form. |
_MasterItemThouSeparator |
The character that describes the thousand section of a number. |
_MasterItemDescription |
The content of the description field of a master item. |
MasterItemImport
Master Items originating from the mpmX Template App inline table. These master items are automatically replacing the placeholding master items in every chart of the mpmX Template App.
Field Name |
Explanation |
MasterItemName |
The name of the master item, which is displayed in the master items panel. |
MasterItemLabel_EN |
The label expression in English which is used by the mpmX Template App to be displayed on the chart axis when using the master item. |
Level |
The level to which the master item belongs, either Event, GeoField or Case. |
MasterItem_Label_EN |
The label expression in English which is used by the mpmX Template App to be displayed on the chart axis when using the master item and switching the app to the optional language by a button.. |
MasterItemLabel_DE |
The German label expression in English which is used by the mpmX Template App to be displayed on the chart axis when using the master item. |
MasterItemDescription_DE |
The content of the description field of a master item in German. |
MasterItemLabel_ES |
The Spanish label expression in English which is used by the mpmX Template App to be displayed on the chart axis when using the master item. |
MasterItemDescription_ES |
The content of the description field of a master item in Spanish. |
Translations
Field Name |
Explanation |
TextObject |
The unique identifier of a text object, that is used in the label-function. |
EN |
The translations (one column per translation) into English, so the language in the front end can be switched with a button. |
DE |
The translations (one column per translation) into German, so the language in the front end can be switched with a button. |
ES |
The translations (one column per translation) into Spanish, so the language in the front end can be switched with a button. |
