Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Qlik Sense - Best practive for global dimensions


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?