Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use
Aggr(SUM(Target),Measure)
Better help can be provided if you can provide sample apps.
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
Hi,
I've attached an example.
I still can't get it to work.
Cheers
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