Mini Chart linear gauges and Lower bounds based on different values

[#1]

Hi,

I have a linear gauge as a mini chart in a table and I want to change the lower bound based on a field i.e. Target. Each Gauge may have a different target there for having a different Lower bound.

Hope this makes sense, I;'ve attached an example that I have created in Excel. The gaguge does not reflect the figures, but it should give you an i dear of what I want to achieve, with the differnt lower bounds.

Cheers

[MK_QSL]

You can use

Aggr(SUM(Target),Measure)

Better help can be provided if you can provide sample apps.

[#3]

Simon Lee,

i saw some threads and also tryed to configure mini charts bounds on table row value. It seems impossible ....

Look also here:

http://community.qlik.com/message/277193#277193

Of course value of your expression is presented on this mini chart ...

regards

Darek

[#4]

Hi,

I've attached an example.

I still can't get it to work.

Cheers

[#5]

Simon,

I prepared 2 charts with my ideas.

Have a look on it.

In table with bar mini chart i showed 2 columns. 2'nd one is only to show, that we may calculate some values on mini chart dimension.  The idea is to use 3 colors of bars - min value, normal value and max value.

Some idea may be also (if you dont have very big data ammounts) to prepare (like in your xls) 10 or 20 columns in your straight table and calculate colors of them...

I hope taht it helps. Let me know

regards

Darek