Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.