0 Replies Latest reply: Feb 2, 2017 1:37 PM by Niklas Andersson RSS

    Qlik Sense - Best practive for global dimensions

    Niklas Andersson

      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?