group dimension in diagramtable

[#1]

Hi togehter,

i have a table diagram like this..

Field A (Dim), Field B (formula), Field C (formula)

F&C     10     3

F&C     13     1

GF1     12     4

GF1     11     6

GF1     10     1

I want to group the first two Fields like this:

(sum the values..)

F&C     23     4

GF1     33     11

How can i do it ?

Thank you very much

[Oleg_Troyansky]

Actually, this is how QlikView charts work by default. If you specify field A as a dimension and create two expressions:

sum(B)

sum(C)

QlikView will aggregate your values by field A, creating exactly the result that you are asking for.

regards,

Oleg

[#3]

Hi Oleg,

thanks for your support.

maybe is this not a good example from me. Look at this table:

The First two field are dimensions. How can i get this table:

F&C     1555684,22€     1841149,78€

G1        caluculating like above..

...

..

.

I want to sum the month from 1-12 Periods. Shoud i use the aggr function ?

Thank you very much,

[#4]

no idea ?

[#5]

You want the total of F & C to show up for every line of the period, or you would like just 1 line for F & C? Removing Period as a dimension will do the later.