topic how do i pivot this? in QlikView

how do i pivot this?

amien — Sat, 23 Jan 2010 21:24:53 GMT

i guess i'm missing something..

i have this table:

id, value1, value2,

1, 10, 20

1, 15, 30

2, 60, 44

2, 45, 33

....

i need this pivot/table:

value1 ,sum(value1)

value2, sum(value2)

and then a split on id on the top.

Sat, 23 Jan 2010 22:16:17 GMT

That looks not like something I have ever seen in QV.

You put columns in lines and add a dimension that is also used in the expression ... ???

Then you want the id on top of that.

The only thing I could create that comes near that is two pivot tables on top of each other. And those barely made sense anymore.

What you can create of course is a pivot table with dimensions id, value1 and value2 and then add the expressions as mentioned.

But perhaps someone else has a good idea for this 🙂

amien — Sat, 23 Jan 2010 23:01:56 GMT

Thanks for your reply ..

You put columns in lines and add a dimension that is also used in the expression ... ???

Then you want the id on top of that.

yap .. thats about it 🙂

trying this also to do this with a load resident .,. but cant get it working

Sun, 24 Jan 2010 11:28:26 GMT

Thought of this this morning 🙂

You can use a new dimension to designate the value type (1 or 2).


Test2:
LOAD * INLINE [
 id2, valuetype, value
 1, 1, 10
 1, 1, 15
 2, 1, 60
 2, 1, 45
 1, 2, 20
 1, 2, 30
 2, 2, 44
 2, 2, 33
];