Top total on bar char gets cut of

[CasperQlik]

Hi Qlik Community

On several figures the top total on my stacked chart gets cut off. Is there a way to force the total to remain?

[Clement15]

Hello,

You can choose and customize a fixed value or a formula if you uncheck this box

[CasperQlik]

I know, the problem with a fixed value is when the user makes selections a fixed value is not always desirable. I would like to keep it dynamic if at all possible.

[Clement15 · Accepted solution]

Do you have an example of what you want?

For example, I regularly use
=ceil(max(aggr(Measure,Dimension)),10)

I replace the 10 with the most consistent number according to the values