Crosstable link field

[#1]

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.

[#2]

Hi,

could you attach a screenshot of your table ( before to do the cross table). If i undertand well you want to get a newfield concatening others

JJ

[#3]

Hi Jean-Jacques, you are correct, I am trying to get a new field concatenating others. I have no problems concatenating fields 1-5. However, the 6th field will not pull in because it is a 'normal' field in the original crosstable. I have attached a screenshot of the original table. Thanks for your help

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/1016.Table.xls:550:0]

[#4 · Accepted solution]

Maybe you could do this in 2 steps:

Table1:

Crosstable(Month, Measure, 5)

Load

@1 as Field1,

@2 as Field2,

@3 as Field3,

@4 as Field4,

@5 as Field5

from your file ...

Load * , Field1 & Field2 &Field3 &Field4&Field5 as LinkField

resident table1;

jj

[#5]

Thank you very much, this works!