topic Re: Mini Chart linear gauges and Lower bounds based on different values in QlikView

Mini Chart linear gauges and Lower bounds based on different values

Mon, 28 Apr 2014 09:44:34 GMT

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

Re: Mini Chart linear gauges and Lower bounds based on different values

MK_QSL — Mon, 28 Apr 2014 09:49:39 GMT

You can use

Aggr(SUM(Target),Measure)

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

Re: Mini Chart linear gauges and Lower bounds based on different values

Mon, 28 Apr 2014 09:51:40 GMT

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

Re: Re: Mini Chart linear gauges and Lower bounds based on different values

Mon, 28 Apr 2014 10:38:39 GMT

Hi,

I've attached an example.

I still can't get it to work.

Cheers

Re: Re: Re: Mini Chart linear gauges and Lower bounds based on different values

Mon, 28 Apr 2014 11:49:05 GMT

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