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

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
Partner - Creator II
Partner - Creator II

Instead max(Sales_Pct), use sum(Sales_Pct)

Not applicable
Author

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?