topic Re: Table layout in QlikView

Table layout

Mon, 30 Jul 2012 14:21:30 GMT

Dear all,

I've this table:

Customer Year Month Group Turnover

A 2012 1 G1 1500

A 2012 1 G2 1000

A 2012 1 G3 500

B 2012 1 G1 200

B 2012 1 G3 400

I would like to produce the following layout:

Customer	Year	Month	Turnover.G1	Turnover G2	Turnover G3
A	2012	1	1500	1000	500

B 2012 1 200 - 400

but I don't know how to do it

Help please

Thanks in advance

swuehl — Mon, 30 Jul 2012 14:44:42 GMT

Create a pivot table chart with dimensions Customer, Year and Month and Group

and expression:

=sum(Turnover)

Drag Group dimension to the top and if you want change the dimension Group to a calculated dimension:

='Turnover '&Group

Hope this helps,

Stefan

Mon, 30 Jul 2012 14:47:37 GMT

Use Transpose()

Tue, 31 Jul 2012 09:40:46 GMT

I think you can use crosstable funtion also!

Tue, 31 Jul 2012 21:16:35 GMT

Thanks again, problem solved. Just one thing: is it possible to calculate the sub-totale labels?

for instance, at the end of group G1, I'm using a simple "total group". I would like "total group G1".

I tried by the & operator, but nothig happens. Do you have a trick ?

Anyway thanks for your support

Stefan

Tue, 31 Jul 2012 21:19:05 GMT

Thanks, but unfortunatly I'm a beginner and I don't know to to use it and in which cases.

Do you have an example ? I'm working with the personal edition.

Thanks in advance