Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table layout

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
A2012115001000500

B              2012 1          200               -                 400

but I don't know how to do it

Help please

Thanks in advance 

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

5 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Use Transpose()

Not applicable
Author

I think you can use crosstable funtion also!

Not applicable
Author

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

Not applicable
Author

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