2 Replies Latest reply: Sep 12, 2016 8:46 AM by Or Shoham RSS

    Qlikview - Variable that assume multiple values

    A v

      Hi experts,

       

      Imagine that I've five (six with the ID) different fields on a Table:

      A

      B

      C

      D

      E

      ID

      And I've another table that have a field that classifies this fields:
      ID
      NOTE1
      NOTE2

       

      Basically my fact tableis:
      ID
      A
      B
      C
      D
      E
      NOTE1
      NOTE2

       

      How can I build a table like this:

       

       

      FieldNOTE1NOTE2
      A
      B
      C
      D
      E

       

       

       

      When I insert the multiple fields into Dimensions I'm getting like this

       

       

      FieldBCDENOTE1NOTE2
      A
      B
      C
      D
      E

       

      Many thanks!