topic Re: Crosstable multiple dimensions in QlikView

Crosstable multiple dimensions

Wed, 25 Nov 2020 16:16:04 GMT

I trying to figure out how to load a crosstable in QlikView. I have managed to do it before, but then I only had one dimension in the columns and now I have two... I would very much appreciate it if someone could help me load attached exceltable into QlikView. The first two columns should be dimensions, as well as the years.

Thank You!

Re: Crosstable multiple dimensions

trdandamudi — Wed, 17 May 2017 14:43:47 GMT

May be as below:

LOAD Company,
Item,
[2013],
[2014],
[2015],
[2016]
FROM

(ooxml, embedded labels, header is 1 lines, table is QV);

Note: Change the path according to your needs....

Re: Crosstable multiple dimensions

Frank_Hartmann — Wed, 17 May 2017 14:45:19 GMT

Try like that:

Re: Crosstable multiple dimensions

prieper — Wed, 17 May 2017 15:01:42 GMT

Crosstable should work

Crosstable

A cross table is a common type of table featuring a matrix of values between two or more orthogonal lists of header data, of which one is used as column headers. A typical example could be to have one column per month. To transform a cross table into a straight table, use a crosstable prefix. The result is that the column headers (e.g. month names) will be stored in one field - the attribute field - and the column data (month numbers) will be stored in a second field: the data field.

The syntax is:

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field name is the field to contain the attribute values.

data field name is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.

Examples:

Crosstable (Month, Sales) Load * from ex1.csv;

Crosstable (Month,Sales,2) Load * from ex2.csv;

Crosstable (A,B) Select * from table3;

Re: Crosstable multiple dimensions

Thu, 18 May 2017 05:08:25 GMT

That works perfect! Thank You