topic Expression and chart in QlikView https://community.qlik.com/t5/QlikView/Expression-and-chart/m-p/351243#M575653 <HTML><HEAD></HEAD><BODY><P>maybe u also need to count distinct MT_Available_Act?</P></BODY></HTML> Wed, 16 May 2012 09:08:42 GMT Anonymous 2012-05-16T09:08:42Z Expression and chart https://community.qlik.com/t5/QlikView/Expression-and-chart/m-p/351242#M575652 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Ihave an expression in chart below.</P><P></P><P>=count(if(MT_AVAILABILITY_ACT&gt;0,MT_AVAILABILITY_ACT))/(count (DISTINCT ID_SEGMENT_CLASS))</P><P></P><P>I want to see rate of this expression actual value not total values I mean <IMG alt="ratio.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/14235_ratio.png" width="450" /></P><P></P><P>When you look at chart you see values like 40000,50000 but I want to show less than 100 percent</P></BODY></HTML> Tue, 15 May 2012 06:15:16 GMT https://community.qlik.com/t5/QlikView/Expression-and-chart/m-p/351242#M575652 QSense 2012-05-15T06:15:16Z Expression and chart https://community.qlik.com/t5/QlikView/Expression-and-chart/m-p/351243#M575653 <HTML><HEAD></HEAD><BODY><P>maybe u also need to count distinct MT_Available_Act?</P></BODY></HTML> Wed, 16 May 2012 09:08:42 GMT https://community.qlik.com/t5/QlikView/Expression-and-chart/m-p/351243#M575653 Anonymous 2012-05-16T09:08:42Z