Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for
Did you mean:
Partner - Contributor

Max value of full accumulated sum in bar chart

Hi community,

I have two bar charts which need to have an equalized scaling.

The scale should be the maximum of the first bar chart. This bar chart has a simple sum()-formula, but with full accumulation.

Have a look at the pictures, I need to get 838 as formula... I tried with rangesum() or rangemax() but didn't get any further.

Thanks a lot for your help!

GraphicsProperties of bar chart

1 Solution

Accepted Solutions

@e_ko  there was typo. Below works

=max( aggr(rangesum(above(total sum(Amount),0,rowno())), (YYYYWW,(NUMERIC,ASCENDING))))

4 Replies

@e_ko  try below. Where highlighted filed is dimension of your chart

=max( aggr(rangesum(above(total sum(Amount),0,rowno()), (Month,(NUMERIC,ASCENDING)))))

Partner - Contributor
Author

Hi @Kushal_Chawda thank you for your reply! I didn't get it to work as it says aggr() needs 2 parameters (?)

I've attached the QVW, maybe you can have a look at it?

@e_ko  there was typo. Below works

=max( aggr(rangesum(above(total sum(Amount),0,rowno())), (YYYYWW,(NUMERIC,ASCENDING))))

Partner - Contributor
Author

Thank you! 🙂

Community Browser