4 Replies Latest reply: Feb 3, 2010 4:50 PM by j-rawk RSS

    Crosstable link field

    j-rawk

      Hi, I am new to Qlikview and not good at understanding the help files yet. I am wondering how I can create a unique field within a cross table. For example, as shown in the bottom line.

      Table1:

      Crosstable(Month, Measure, 6)

      Load

      @1 as Field1,

      @2 as Field2,

      @3 as Field3,

      @4 as Field4,

      @5 as Field5,

      (@1&@2&@3&@4&@5&[Month]) as LinkField,

      It seems that I cannot concatenate [Month] as a field to create my final link value, I appreciate any suggestions.