topic Turn table - how? in QlikView

Turn table - how?

giovanneb — Fri, 02 Dec 2011 13:59:31 GMT

Hello I have the following situation in the table below:

product	collection	line
16301	10
16301		30

By rotating the table would have to be like this:

product	collection	line
16301	10	30

How to do it?

Thanks

jagan — Fri, 02 Dec 2011 14:06:46 GMT

Hi,

Add Product as Dimension, and add Sum(Collection) and Sum(Line) as expressions.

Regards,

Jagan.

Fri, 02 Dec 2011 14:07:11 GMT

If you are ok with having an empyty column you can do this:

Create a straight table with dimensions product, collection, and line.

create an expression like: if(1=1,'') with the lable of the chart as '

giovanneb — Fri, 02 Dec 2011 15:51:04 GMT

forgot to say that this had to be treated in the data load, I'm reading an excel spreadsheet and would leave the QVD gave as presented

swuehl — Fri, 02 Dec 2011 16:22:24 GMT

Try using a LOAD with group by clause and summing the columns:

LOAD

Sum(collection) as collection,

Sum(line) as line,

product

from Table.xls group by product;

Hope this helps,

Stefan