crosstable?

ali_hijazi — Fri, 08 Jul 2011 08:47:38 GMT

Hello

may someone explains to me how crosstable works?

supplying example is appriciated

kaushiknsolanki — Fri, 08 Jul 2011 09:05:40 GMT

Hi,

Definition: -

Cross table Or Cross Tabulation is the process of creating a contingency table from the multivariate frequency distribution of statistical variables.

Cross Table Look like this.

In an original Table 2001,2002,2003 is a field, but in a crosstab presentation it is shown as above.

Now consider that you have data in this format and you want to get this data into Qlikview.

Qlikview allows to fetch such kind of data using the Crosstable.

Say you have such data in xls file.

When you fetch this data in qlikview, in File Wizard you get an option called CrossTable.

Click on that here wizard will ask you for the Qualifier Field.

Meaning The no of fields from left which are in proper form. So considering the above shown table, your qualifier will be 2.

Now It will ask for the Attribute Field.

This is nothing but the name for the field which is shown as field in the shown table.

So here 2001, 2002 and 2003 is Year, So you will type year.

And the last is Data Field.

This is nothing but the name for the values in the Field.

So in our example the name for the values like 150,153......

Click finish and your load script will look like this.

CrossTable(Year, Data, 2)

Load Category,

Type,

2001,

2002,

2003,

[Grand Total]

From xyz.

Hope this will clear to you.

Regards,

Kaushik Solanki

topic crosstable? in QlikView