Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
robynrshields
Contributor III
Contributor III

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

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.

ReportCardImage.png

 

Here's the settings for the Linear Gauge chart:

Linear Gauge Settings.png

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?

1 Reply
johnmahoney
Contributor III
Contributor III

Hi

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)))