Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
neale1970
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
robin_hausdoerfer
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...

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

neale1970
New Contributor III

Re: Qlik Sense; Cross Table with multiple attributes.

‌Thanks Martin, will give that a go.

NEale

d_prashanthredd
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;

ahaahaaha
Honored Contributor

Re: Qlik Sense; Cross Table with multiple attributes.

Hi,

look attached file


Andrey