Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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

View solution in original post

3 Replies
swuehl
MVP
MVP

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
Author

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
Author

Hi Stefan,

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

Thank you very much