topic collapsed rows do not sum the present values ? in QlikView

collapsed rows do not sum the present values ?

Wed, 23 Nov 2011 16:31:53 GMT

HelloTogehter,

can someone explain me why the collapsed rows in this case do not sum the existing 3 values ?

status expanded row:

status collapsed row:

I had expected that the 3 values in the expanded rows [0,00 € +0.00 € + €20,253.88] are summed in the collapsed row. Instead of the expected value of 20.253.88 € .

An example of qvw file is attached. Thank you for any help.

Best Regards,

collapsed rows do not sum the present values ?

swuehl — Wed, 23 Nov 2011 17:37:05 GMT

You probably need to use an aggregation function, like

=sum(PD_AGGREGATED_WERT)

insetad of just using the Fieldname

=PD_AGGREGATED_WERT

which is ambiguous if you collapse the rows.

Hope this helps,

Stefan

collapsed rows do not sum the present values ?

Wed, 23 Nov 2011 23:34:16 GMT

Hi Stefan,

not really

Unfortunately i didnt understand your response. Should the collapse action of the shown row not to sum all included

underrows to one value ?

Thank you for your advice

Best Regards,

Hon

collapsed rows do not sum the present values ?

Thu, 24 Nov 2011 10:44:52 GMT

Hi Stefan,

sorry I've mistaken for the problem. It works!

Thank you very much