topic CREATING A GAUGE CHART WITH TIMES in QlikView

CREATING A GAUGE CHART WITH TIMES

Mon, 26 Jul 2010 21:19:40 GMT

Hy, i need your help.

I´m trying to make a gauge chart with AVG times.

See the image.

The time have to do this.

00:00 to 01:00 GREEN

01:00 to 02:00 YELLOW

> 02:00 RED

Here is my informations (data)

I´m using a AVG function in qlikview to generate de AVERAGE of times like this

=avg(distinct(time))

My load contain

TEMPO_VERDE:
LOAD

TIME
FROM

D:\HGP_BI\QVDS\tempo_cadastro_atend_verde.qvd (qvd);

How can I do this?

Tue, 27 Jul 2010 09:28:28 GMT

This is a very simple example but something that you can work with

Tue, 27 Jul 2010 11:58:22 GMT

Try the following code

avg(hour(Time) + minute(Time)/60 + second(Time)/3600)

Tue, 27 Jul 2010 12:40:24 GMT

Hy, thanks.

The average is work. Just avg(time).

My problem is how to make a gauge chart with diferents points like

SEGMENT1 00:00 TO 01:00

SEGMENT2 01:00 TO 02:00

SEGMENT3 02:00 TO 03:00

Would you help me?

Wed, 28 Jul 2010 09:30:41 GMT

Did you try opening the attached demo in the previous post? If this can not help you will you attach your file / chart

Wed, 28 Jul 2010 09:48:32 GMT

Hi,

here is an example to your question.
You can set the segments with a formula like 'time#('01:00','hh:mm')'.
Hope, that helps.

Stefan

Wed, 28 Jul 2010 10:29:01 GMT

in the presentation tab.

untick autowidth segments and relative segment bounds and then select the segements and enter your segment boundries as e.g.

='01:00:00'

with the apostrophes.