Limit value to 100% in Qlik Sense Front End

[that_anonymous_guy]

I have a line chart in the front end which is basically a progress chart. I am using this formula to in the Y-axis

sum(WeeklyProgress)

The problem is that the weekly progress sometimes exceeds 100% like it gives values like 100.04 and because of this the chart in the Y-axis goes up till 150%( as it is coming with a gap of 50) so to accommodate 100.04 it gives axis till 150.

I don't want that...I want the axis till 100 only so I have applied an if statement to it but it's still showing the same thing

if(sum(WeeklyProgress) > 100,  100, sum(WeeklyProgress))

Can anyone help me with this?

Thanks

[adithyarpai]

have you tried limiting the range ?