Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Expression

Can anyone help me figure out how to get my speedometer guage to show the right thing? My expression is as follows:

=count({$<Status={'Complete'}>}Field)/Count(Field

That expression equals 0.57, and my guages are set at Min=0 and Max=1. But the guage says it equals 1. What am I doing wrong?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

use total function in the denominator ->count(total(field))

View solution in original post

3 Replies
Anonymous
Not applicable
Author

use total function in the denominator ->count(total(field))

Not applicable
Author

Thank you!!

Not applicable
Author

Or use:

count({$<Status={'Complete'}>}Field) / count({$<Status=>}Field)