Discussion Board for collaboration on QlikView Scripting.
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.
you can do like this
crosstable (field,values) dim;
and if you want the crosstable key word
crosstable (month,values) any ex.....