Qlik Sense; Cross Table with multiple attributes.

[Anonymous]

‌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 ?

thanks

Neale

[Anonymous]

you can use crosstable load,

easiest would be you upload an Excel file with some sample data and original header...

[martinpohl]

Hello,

you can use crosstable load with multiple Attributes. You have to define it in the crossload Option.

Use

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.

Regards

[Anonymous]

‌Thanks Martin, will give that a go.

NEale

[d_prashanthredd]

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.

Ex;

CrossTable (YearQtr, QtrValue, 4)

load CRM#, StrikeRate, Amount, Colx, 2017-Q1, 2017-Q2, 2017-Q3, 2017-Q4 from XXXXX;

[ahaahaaha]

Hi,

look attached file

Andrey