Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
New Contributor III

Qlik Sense; Cross Table with multiple attributes.

‌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

5 Replies
Highlighted
Valued Contributor III

Re: Qlik Sense; Cross Table with multiple attributes.

you can use crosstable load,

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

Highlighted
Partner
Partner

Re: Qlik Sense; Cross Table with multiple attributes.

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

New Contributor III

Re: Qlik Sense; Cross Table with multiple attributes.

‌Thanks Martin, will give that a go.

NEale

Highlighted
Contributor III

Re: Qlik Sense; Cross Table with multiple attributes.

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;

Highlighted
Honored Contributor

Re: Qlik Sense; Cross Table with multiple attributes.

Hi,

look attached file


Andrey