Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

collapsed rows do not sum the present values ?

HelloTogehter,

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

status expanded row:

open.JPG

status collapsed row:

close.JPG

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,

1 Solution

Accepted Solutions
MVP
MVP

collapsed rows do not sum the present values ?

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

3 Replies
MVP
MVP

collapsed rows do not sum the present values ?

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

Not applicable

collapsed rows do not sum the present values ?

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

Not applicable

collapsed rows do not sum the present values ?

Hi Stefan,

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

Thank you very much

                                                 

Community Browser