Hi,
I'm new to Qlik Sense, after previous work with OBIEE and Hypergene.
I have a fact table for 20+ fields, where some of the fields contains dimensions with only numeric values, i.e {1,2,3,4,5}. These values have a meaning, e.g 1 = EDI-order, 2 = Phone order, 3 = Mobile order and so on. Therefore I would like the labels to be {EDI-order, Phone order, Mobile order...} instead of {1,2,3...} when using the dimension in an app/sheet..
What is the best way of doing this?
- In my fact table before import to Qlik Sense?
- By importing additional data tables with dimension-labels and associate them in Qlik Sense Data manager?