topic Re: group dimension in diagramtable in QlikView

group dimension in diagramtable

Mon, 30 Apr 2012 14:34:09 GMT

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

group dimension in diagramtable

Oleg_Troyansky — Mon, 30 Apr 2012 15:23:20 GMT

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

Re: group dimension in diagramtable

Mon, 30 Apr 2012 16:26:57 GMT

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,

Re: group dimension in diagramtable

Thu, 10 May 2012 14:48:23 GMT

no idea ?

Re: group dimension in diagramtable

Thu, 10 May 2012 14:57:34 GMT

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.