5 Replies Latest reply: Dec 2, 2014 5:30 AM by Malek Safa RSS

    Best Practice on Data Structure lots of Types

      Hi,

       

      I was been told by one of my Qlikview seniors in the following scenario.  Would like to ask on the guidance on how to approach this.

       

      Example:

      In a Qlikview table structure, there are quite a few departments with numeric types assigned.

      Example, Sales -0, Engineer -1 , Education -2, Marketing -3, R&D -4,etc.

       

      At dashboard level, it will be not be effective to use the following expression:

      =If (Department = 'Sales', ....)

      OR

      =If (Department = 0, ....)


      What he suggested is to break up this different departments into different table structures as this will reduce the IF expression in the dashboard level as we are manipulating the data at script level.


      Can anyone guide me on this approach?


      Thanks

      Chun Wey