topic Dynamic Limits in Gauge Chart in QlikView

Dynamic Limits in Gauge Chart

Wed, 03 Jun 2009 05:24:38 GMT

Hi,

In my project there is a requirement to calculate Simple Moving average for Stocks and same needs to be displayed in the Guage Chart. The Green, Amber and Red segment I need to set the values dynamically. How should I set the Min and Max with respect to the Segments in the Guage chart?

Any help or thoughs on the same will be help.

Regards,

Amit Somani

Dynamic Limits in Gauge Chart

johnw — Wed, 03 Jun 2009 05:48:51 GMT

On the presentation tab, you can remove the checkmark on Autowidth Segments. You can then enter expressions for the min, max, and where each segment starts. If you already knew that, and need help with the expressions themselves, I'll need more detail.

Dynamic Limits in Gauge Chart

Oleg_Troyansky — Thu, 04 Jun 2009 01:25:32 GMT

Amit,

(if you are still following this hot discussion...)

Min, Max, as well as Segment boundaries are all Expressions, and you can use any calculations you want there. For the segment boundaries, you might need to uncheck "Autowidth Segments", as John rightfully suggested.

regards,

Oleg

Dynamic Limits in Gauge Chart

Fri, 05 Jun 2009 05:00:14 GMT

Thanks for all your help. I am able to create Dynamic Gauge charts