Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Crosstable in script


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

Tags (2)
1 Reply
Not applicable

Crosstable in script


you can do like this

crosstable (field,values) dim;

and if you want the crosstable key word

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