topic Re: Gauge Chart - Set Flexible Max Value in QlikView

Gauge Chart - Set Flexible Max Value

Wed, 05 Mar 2014 11:13:06 GMT

Hi, when I create a Gauge Chart, I don't want to hardcode the Max value (Presentation tab).

Example:

if sum(sales) = 105, then Max Value=1000

if sum(sales)= 2090, then Max Value=10,000

Can guide me how to use the expression?

Thanks you

Benjamin See

MK_QSL — Wed, 05 Mar 2014 11:17:55 GMT

Go to Properties of your chart

presentation tab

Guage Settings

Under Max write down below expression

IF(Sum(Sales) = 105, 1000, If(Sum(Sales) = 2090, 10000))

UPDATE:

Another way is to set max at 10% higher

Please check enclosed file.

Thu, 06 Mar 2014 02:24:45 GMT

Thanks. Test ok.