|
Understand the MPM Master Item and Language Tables |
Scroll Previous Topic Top Next Topic More |
The MPM Master Item and Language Tables are created from the belonging csv-files of the MPM 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 avaibable languages for the MPM Template App Mulitlanguage. |
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_EN |
The label expression in English which is used by the MPM Template App English to be displayed on the chart axis when using the master item (Qlik Sense® September 2017 or later). |
_MasterItemLabel |
The label expression in multilanguage-format which is used by the MPM Template App Multilanguage 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_EN |
The field name or expression for the measure or dimension used by the MPM Template App English. |
_MasterItemExpression1 |
The field name or expression for the measure or dimension used by the MPM Template App Multilanguage. |
_MasterItemDescription |
The content of the description field of a master item. |
_MasterItemColor |
The HEX code to define the color of the master elements, which is in the format "#000000" or null(). |
_MasterItemTags |
A list of terms that are used to tag the master item. |
_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 MPM Template App. |
MasterItemImport
Master Items originating from the MPM Template App inline table. These master items are automatically replacing the placeholding master items in every chart of the MPM 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 MPM Template App Multilanguage to be displayed on the chart axis when using the master item. |
MasterItemLabel |
The label expression in English which is used by the MPM Template App English 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. |
MasterItemDescription |
The content of the description field of a master item. |
MasterItem_Label_{optionalLanguage} |
The label expression in another language which is used by the MPM Template App Multilanguage to be displayed on the chart axis when using the master item and switching the app to the optional language by a button.. |
Translations
Field Name |
Explanation |
TextObject |
The unique identifier of a text object, that is used in the label-function. |
EN | DE or other language |
The translations (one column per translation), so the language in the front end can be switched with a button. |
