topic Re: Crosstable question in QlikView

Crosstable question

russell_angus — Thu, 11 Jul 2013 09:32:01 GMT

I have a table in excel which has one dimension as the rows, and another dimension as the columns. The data values are all either true or false.

E.g.

Dim2

Dim1 X Y Z and so on...

A T F F

B F T F

C F T T

and so on...

So far so good...

When I use the crosstable function in the load statement it includes the first column header as one of the data values, in my example above the X.

What I want is:

Dim1 Dim2 Data

A X T

A Y F

A Z F

etc

Can anyone help?

kaushiknsolanki — Thu, 11 Jul 2013 09:42:08 GMT

Hi,

Try this way.

DATA:
Load * inline [
Dim1,X,Y,Z
A,T,F,F
B,F,T,F
C,F,T,T
];

CrossTable (Dim2,Value,1)
Load Dim1,
X,
Y,
Z
Resident DATA;

Regards,

Kaushik Solanki

Thu, 11 Jul 2013 09:49:28 GMT

Temp:
Load * inline [
Dim1,X,Y,Z
A,T,F,F
B,F,T,F
C,F,T,T
];

CrossTable (Dim2,Value,1)
Load Dim1,
X,
Y,
Z
Resident Temp;

er_mohit — Thu, 11 Jul 2013 09:54:01 GMT

see the attached file

output this