Cross Table

Tue, 31 Mar 2015 07:20:01 GMT

HI All,

I have a script which has 42 rows , I took the resident of Branch and using

CrossTable(PAD_Type,PAD_Description,40) i got the vertical rows with a column name as

PAD_Type and conetename as PAD_Description,

Now my question is , suppose i need to convert the row number 12 and give it as a name Cass and Row number 13 as the content of the Class

how do i writ this in cross table ?

Re: Cross Table

Tue, 31 Mar 2015 11:26:42 GMT

Please check this

Read the concepts of crosstable.

Crosstable

A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. To turn a cross table into a straight table, use a cross table prefix.

The syntax is:

crosstable (attribute field , data field ,Qualifier)

Crosstab Wizard

The crosstab wizard is dialog driven method of creating the cross table syntax. This dialog is opened by clicking the Cross Table button in the Options page of the File Wizard. The crosstab wizard holds the following options:

where:

Qualifier Fields	The number of qualifier fields that precede the fields to be transformed.
Attribute Field	The name of the new field that will contain all the fields (attribute values) to be transformed.
Data Field	The name of the new field that will contain the data of the attribute values.

topic Cross Table in QlikView

Cross Table

Re: Cross Table

Crosstable

Crosstab Wizard