6 Replies Latest reply: May 4, 2012 9:34 AM by Jonathan Dienst RSS

    Crosstable Field - Doubt to concatenate fields

      Good day,

       

      My friends, i've got a crosstable as below:

       

      KEY:

      CROSSTABLE(Month, Data)

      LOAD Location,

      [01/01/2012],

      [01/02/2012],

      [01/03/2012],

      [01/04/2012],

      [01/05/2012],

      [01/06/2012],

      [01/07/2012],

      [01/08/2012],

      [01/09/2012],

      [01/10/2012],

      [01/11/2012],

      [01/12/2012]

      FROM [...];

       

      The qualifying field is Location, but I really need to create a Location&Month field. (Month is not a qualifying field)

      How can I create it?? I've tried to input like this below, but it shows an error that it didn't find the field:

       

      Example:

      KEY:

      CROSSTABLE(Month, Data)

      LOAD

      Location,

      Location&Month,

      [01/01/2012],

      [01/02/2012],

      ...

       

      Hope you masters of QlikView can help me.

       

      Kind rgds, Jorge.