topic Re: Gauge and last value Problem in QlikView

Gauge and last value Problem

Tue, 12 Jun 2012 09:27:51 GMT

Hello everyone, I’m trying to find out a solution to this problem:

I have the following fields:

-System (Each element belong to one System)

-Element

-Date (There is a lot of data)

-Value (Engineering value (Positives and negatives values))

What I need to do it creates a Gauge Chart for each System, with show the Value of the last Date.

The limits of the Gauge must be the minimum and the maximum value from the available and possible data (Considering that each element count with different data that’s depend principally in the System)

Hopefully you can find the answer

Re: Gauge and last value Problem

christophebrault — Tue, 12 Jun 2012 09:39:36 GMT

Hi,

Without testing this solution, i can advice this :

create a simple table chart with system and element as a dimension

expression :

only({$<Date={$(=Max(Date))}>}Value) This will show only the value with the max Date for each system and element

choose gauge as representation and set min and max :

min : =Min(Value)

max : =Max(Value)

Re: Gauge and last value Problem

jonathandienst — Tue, 12 Jun 2012 10:01:59 GMT

Are the guages you need inside a table, in a trellis or individual standalone guages?

Jonathan

Re: Gauge and last value Problem

Tue, 12 Jun 2012 10:36:51 GMT

Hi Jonathan,

There are Individual Standalone Gauges

In moment I try luck with the expresion from cristoph...

Thanks...