topic Tacometro in QlikView

Tacometro

Tue, 18 Dec 2012 00:51:04 GMT

hi,

i have the following data:

SITIO	CAPACIDAD TANQUE GL	SUMINISTRADO
BOGOTA	500	400
CALI	700	600
MEDELLIN	600	550
BUCARAMANGA	800	400

i wanna plot the following:

i want used this chart

i need show the capacity free

example:

bogota: 400/500= 80%

i wanna that this value to be indicated

this is posible?

thank you

sorry my english

Re: Tacometro

Anonymous — Tue, 18 Dec 2012 01:52:52 GMT

If you want to make a gauge specifically for BOGOTA you could use an expression like:

sum({$<SITIO={'BOGOTA'}>} SUMINISTRADO/[CAPACIDAD TANQUE GL])

Re: Tacometro

Tue, 18 Dec 2012 06:03:58 GMT

Hi,

In the requirement your data has 4 SITIO. The gauge(tacho) chart can display only on of them at one time. Hence you will have to slect the particular SITIO.

Else you could display all the SITIO side by side, like a clusture of charts like this

.. For this you will have to use Trellis option at the bottom in the Dimensions tab of the Chart properties.

You will be able to define the color in the presentation tab.

Attached is an sample qvw.

Hope this helps.

Thanks

SITIOSITIO

Re: Tacometro

Tue, 18 Dec 2012 15:32:23 GMT

hi,

thank you fahadkhanbi

can you write the expresion?

Re: Tacometro

Wed, 19 Dec 2012 05:33:38 GMT

Hi,

The expressiong is the same "=SUMINISTRADO/[CAPACIDAD TANQUE GL]"

It is in the qvw attached in the previous reply.

Thanks