topic Crosstable link field in QlikView

Crosstable link field

Wed, 03 Feb 2010 19:42:09 GMT

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.

Crosstable link field

Wed, 03 Feb 2010 21:02:31 GMT

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

Crosstable link field

Wed, 03 Feb 2010 21:14:57 GMT

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]

Crosstable link field

Wed, 03 Feb 2010 21:36:47 GMT

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;

Crosstable link field

Wed, 03 Feb 2010 21:50:42 GMT

Thank you very much, this works!