Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP
MVP

Re: Table layout

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

5 Replies
MVP
MVP

Re: Table layout

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

Re: Table layout

Use Transpose()

Not applicable

Re: Table layout

I think you can use crosstable funtion also!

Not applicable

Re: Table layout

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

Re: Table layout

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