topic Re: Gauge parameters inside a straight/pivot table in QlikView

Gauge parameters inside a straight/pivot table

Clever_Anjos — Wed, 25 Sep 2013 15:32:53 GMT

I´m trying to set different parameters to a gauge inside a straight/pivot table.

I would like, for example depending of a "country" (see picture) set different thresolds to indicate what is 'good' or 'bad'

I´ve tried to put something like into lower bound box

if(Country = 'Brazil',10,

if(Country = 'Argentia',5,3)

QlikView interface permits that expression, but does not work (I really don´t know if its a bug or not implemented this way)

Re: Gauge parameters inside a straight/pivot table

vikasmahajan — Wed, 25 Sep 2013 15:50:01 GMT

pfa

Re: Gauge parameters inside a straight/pivot table

Clever_Anjos — Wed, 25 Sep 2013 15:59:26 GMT

Vikas, this screen ir for Gauge Object, not a gauge expression inside a table

Re: Gauge parameters inside a straight/pivot table

simondachstr — Wed, 25 Sep 2013 16:41:48 GMT

Hi Clever,

I tested something similar myself putting an expression into the lower and higher bound calculation of a gauge chart, however without success. It seems that it only accepts ONE numerical value and can not calculate it for each row, thus making individual gauges depending on the Country as you wish.

Furthermore, while searching the QV forums I found following thread, which quotes a response from the QV team concerning this:

We have been looking into the possibilities of having individual line gauges in a straight/pivot table, but unfortunately it seem there that there is no possibilities for that. What you would need is to have them as different object in your application or some other solution, but getting individual line gauges inside a table like in your example doesn't seem possible at this moment.

I hope I could help you with that.

Re: Gauge parameters inside a straight/pivot table

Clever_Anjos — Wed, 25 Sep 2013 16:49:28 GMT

Thank you Martin Mahler.

Unfortunately creating different objects is not a good option to me, because I would like to respond to selections in a intuitive way.

Thank you

Re: Gauge parameters inside a straight/pivot table

Oleg_Troyansky — Wed, 25 Sep 2013 20:21:53 GMT

Clever,

For the Gauges embedded in Straight Tables, the size of the segments is calculated once per chart (just like Set Analysis conditions), and therefore there is no way to set different segment boundaries for different lines in the chart.

The only thing you can possibly do, as a work around, is to "normalize" the data to a single "target" and to present something like "Actual to target" calculation. This way, the targets may be different for different countries, but "Actual to Target" will always be normalized - you are either above target (green) or below it (red).

I know it's not perfect, but this is perhaps the best work around I could come up with...

cheers,

Oleg Troyansky

www.masterssummit.com

Re: Gauge parameters inside a straight/pivot table

Clever_Anjos — Wed, 25 Sep 2013 20:47:36 GMT

Thanks Oleg

Re: Gauge parameters inside a straight/pivot table

Clever_Anjos — Thu, 26 Sep 2013 18:45:00 GMT

I´ve implemented an extension to solve my needs.