Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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]
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
Thank you very much, this works!