Crosstable in script

Wed, 16 Jun 2010 13:31:00 GMT

Hello,

I have the next data:

DIM1, Field1, Field2, Field3

A 1 0 0

A 0 6 0

A 6 0 0

A 0 0 7

I want to make a crosstable like this:

DIM1, Field1.1, Field1.2, Field2.1,Field3.1

A, 1 6 6 7

I hope someone can help me.

TNX, Halmar

Wed, 16 Jun 2010 14:46:38 GMT

HI,

you can do like this

crosstable (field,values) dim;

and if you want the crosstable key word

crosstable (month,values) any ex.....

regards

Abdalla

topic Crosstable in script in QlikView