Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Setting max y-axis range for bar charts

Hi,

I have a stacked bar chart with all measures summing up to 1. I would like to use the custom max expression to set the max to 1. I don't want to use static max value because the max might change later. I have tried max(Sales_Pct) without success. Please give me some suggestions!

Thanks.

2 Replies
santhoo_san
Contributor II

Re: Setting max y-axis range for bar charts

Instead max(Sales_Pct), use sum(Sales_Pct)

Not applicable

Re: Setting max y-axis range for bar charts

Hi Santhosh, that doesn't work because my bar chart is across time. Say I have 10 bars, then sum(Sales_Pct) = 10 but I need it to be 1. I tried =avg(sum(Sales_Pct)) but that doesn't seem to work as well... any suggestion?