Max Value for Gauge settings gives error message when select on Dimension

Anonymous — Fri, 13 Jul 2018 21:58:55 GMT

I have a chart with 5 linear gauges and it works fine. However, when user selects on the only Dimension in the chart (Agent Name) and if the value for the expression is 0 then the Linear Gauge displays ‘Bad Min or Max Value in Gauge’. I would expect that the Linear Gauge would show nothing.

Here's example when user selects on Agent Name that has 0 values for 3 expressions.

Here's the settings for the Linear Gauge chart:

Max value is set to formula: max(aggr(sum({$< AgentLoginID-={'none'} >} FlagFUFax), AgentNameLastFirst))

How do I get rid of the message '‘Bad Min or Max Value in Gauge’ from displaying in my chart?

Re: Max Value for Gauge settings gives error message when select on Dimension

johnmahoney — Fri, 24 Jan 2020 14:58:32 GMT

I happens when your calc =0, so edit your max value with an if statement

If(max(aggr(sum({$< AgentLoginID-={'none'} >} FlagFUFax), AgentNameLastFirst)) = 0,1,

max(aggr(sum({$< AgentLoginID-={'none'} >} FlagFUFax), AgentNameLastFirst)))

topic Re: Max Value for Gauge settings gives error message when select on Dimension in QlikView

Max Value for Gauge settings gives error message when select on Dimension

Re: Max Value for Gauge settings gives error message when select on Dimension