Gauge chart not displaying correct value when duration format is used

[tm14]

I'm trying to create a gauge chart to show an avg. response time measure in the duration format pattern 'hh:mm:ss'. The expression correctly evaluates to 00:00:04

But there are two issues with the gauge:
- The needle doesn't point to 00:00:04 
- The scaling of the labels is all messed up (look at the distance between 00:00:00 and 00:00:01)

Any help would be much appreciated!

I set the max limit to be 10 seconds in the following way:

[WaltShpuntoff]

I would just convert everything to seconds and try that first. Relying on floating point numbers for dimensions is something I avoid.

Things to keep in mind:

Qlik uses the same underlying date scheme as Excel, so you can always check things based on that.

The integer part of a date/time is just the date. The fractional part is the time in minutes / 1440.

# Minutes in a day = 1440

# Seconds in a day = 86,400

Make sure that your values are what you think they are. When you are dealing with durations you need to be extra careful.

-ws