topic Re: how to calculated value expression between guage charts in QlikView

how to calculated value expression between guage charts

alishankhaliqe — Wed, 25 Nov 2020 16:16:04 GMT

i am working with guage charts but some problem in my chart i cant get result to calculated expression

vinieme12 — Wed, 03 Aug 2016 12:42:03 GMT

can you post your chart expression an also the Min and Max expression for your gauge?

alishankhaliqe — Thu, 04 Aug 2016 19:29:40 GMT

Expression

=Num(Sum([# Departures Performed]) / Sum([# Departures

Scheduled]), '##.#%')

Min = 0.5

Max = 1.2

alishankhaliqe — Thu, 04 Aug 2016 19:33:03 GMT

i can't get answer sir let me know please vinieme12‌

vinieme12 — Fri, 05 Aug 2016 10:31:45 GMT

Hi,

Firstly you don't really need to do Num formatting in your expression, Select

"Number" Tab >> Select your expression on the left space >> Check Fixed >> number of Decimals and

Select Show in Percentage at the bottom.

when you hover over the gauge needle what value is shown ? and what is the expected value when you manually evaluate the percentage?

Fri, 05 Aug 2016 13:04:05 GMT

I would suggest to test the expression in Straight Table first, to see what are possible values for Min and Max values.

After that you can make a decision what values you want to use for Min and Max in Gauge chart.