topic Re: Chart Expression in QlikView https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337281#M492046 <HTML><HEAD></HEAD><BODY><P>use total function in the denominator -&gt;count(total(field))</P></BODY></HTML> Fri, 03 Aug 2012 14:30:20 GMT Anonymous 2012-08-03T14:30:20Z Chart Expression https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337280#M492045 <HTML><HEAD></HEAD><BODY><P>Can anyone help me figure out how to get my speedometer guage to show the right thing? My expression is as follows:</P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">={'Complete'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P><P></P><P></P><P>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?</P></BODY></HTML> Fri, 03 Aug 2012 14:28:55 GMT https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337280#M492045 2012-08-03T14:28:55Z Re: Chart Expression https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337281#M492046 <HTML><HEAD></HEAD><BODY><P>use total function in the denominator -&gt;count(total(field))</P></BODY></HTML> Fri, 03 Aug 2012 14:30:20 GMT https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337281#M492046 Anonymous 2012-08-03T14:30:20Z Re: Chart Expression https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337282#M492047 <HTML><HEAD></HEAD><BODY><P>Thank you!!</P></BODY></HTML> Fri, 03 Aug 2012 14:31:58 GMT https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337282#M492047 2012-08-03T14:31:58Z Re: Chart Expression https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337283#M492048 <HTML><HEAD></HEAD><BODY><P>Or use: </P><P><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">={'Complete'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field</SPAN><SPAN style="font-size: 8pt;">) / </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">=&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field)</SPAN></P><P></P><P></P></BODY></HTML> Fri, 03 Aug 2012 14:33:13 GMT https://community.qlik.com/t5/QlikView/Chart-Expression/m-p/337283#M492048 2012-08-03T14:33:13Z