topic Static max axis problem in QlikView

Static max axis problem

Wed, 13 Mar 2013 17:37:42 GMT

Hello,

I have created a chart where I want the static max axis value to be set to the dimension total value under the current selections

I have the graph showing the dimension total by selecting that option under dimension limits.

I can't figure out how to set the axis max to that total value, I can only get it to set to the dimension max values which obviously skews the visualization of having the total bar added into the chart.

Thanks,

Re: Static max axis problem

Gysbert_Wassenaar — Wed, 13 Mar 2013 17:45:49 GMT

max(total <MyDimension> MyValue) or maybe max(total MyValue). Not sure what you're looking for. Try both options and see if one does what you need.

Re: Static max axis problem

Wed, 13 Mar 2013 18:00:07 GMT

The problem with those expressions is that it is picking the total max value from the entire database field

I am looking for it to pull the total value based on the selections already made.

So my values shown in the chart are changing depending on current selections, currently the chart shows the total value by selecting it as I mentioned above.

I want the max axis to be that total value.