Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alishankhaliqe
Contributor III
Contributor III

how to calculated value expression between guage charts

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

Engineer
5 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
alishankhaliqe
Contributor III
Contributor III
Author

Expression

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

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

Min = 0.5

Max = 1.2

Engineer
alishankhaliqe
Contributor III
Contributor III
Author

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

Engineer
vinieme12
Champion III
Champion III

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?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable

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.