topic Help with charts in QlikView

Help with charts

hopkinsc — Wed, 30 Dec 2009 23:03:07 GMT

Hi all, i have got a GAUGE chart which i am using to display cash shortages from shops. at the moment the scale of the GAUGE is displayed as -£100 to +£100. Is there a way of the scale automatically changing to display a higher or lower scale depending on the actual cash shortage?

E.g. If the shortage is £250, then the GAUGE doesn't display anything as the shortage is out of the scale range (-£100).

In the above example i would like the scale to change to something like -£400 to £0.

Can this be done?

Help with charts

Qlik_Trigg — Thu, 31 Dec 2009 03:17:26 GMT

You'll need to define expressions that set the min/max values on the Gauge - see the presentation tab. An example of this can be found in the 'Online Sales' qvw that is installed (complete install) with the product. Check the Dashboard tab of this screen and then note the behavior of the 3 gauge. There you will see that as you select values in the list bxoes that the min/max change. The expressions o nthe presentation tab for min/max hopefully give you some insight in how to set this up in your application.

Help with charts

stephencredmond — Thu, 31 Dec 2009 05:53:07 GMT

I often recommend that you don't do this!

Sometimes it can be confusing for users if these are dynamic.

Stephen

Help with charts

Sun, 10 Jan 2010 23:32:46 GMT

I agree ...

You could change to a percentage scale though. That way everybody understands what is shown, even when the original scale changes.