Discussion board where members can get started with Qlik Sense.
Hi QS Community,
I am trying to create a cross table from the following data so I can build an area graph.
Table Header: CRM#, StrikeRate, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4, etc
Example data: 3333, StrikeRate1, 1,2,3,4
I need data to look like this ;
3333, StrikeRate1, 2017-Q1, 1
3333, StrikeRate1, 2017-Q2, 2
3333, StrikeRate1, 2017-Q3, 3
3333, StrikeRate1, 2017-Q4, 4
I can't seem to be able to use the crosstable function with more than one attribute. Is this possible ?
you can use crosstable load,
easiest would be you upload an Excel file with some sample data and original header...
you can use crosstable load with multiple Attributes. You have to define it in the crossload Option.
Crosstable (Quarter,Value,2) LOAD * from yourdata.
The parameter 2 is
the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.
Thanks Martin, will give that a go.
CrossTable (YearQtr, QtrValue, 2)
load CRM#, StrikeRate, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4 from XXXXX;
1st Attribute - YearQtr = Name the column (**Can be anything) - The column which you want to be represented as row
2nd Attribute - Values in converted column (Naming convention can be anything)
3rd attribute = no of remaining columns which you want to keep as it is.
CrossTable (YearQtr, QtrValue, 4)
load CRM#, StrikeRate, Amount, Colx, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4 from XXXXX;
look attached file