topic Charts in QlikView https://community.qlik.com/t5/QlikView/Charts/m-p/348629#M577914 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using the Aggr() in place of Only().</P><P></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 12 Apr 2012 10:22:02 GMT jagan 2012-04-12T10:22:02Z Charts https://community.qlik.com/t5/QlikView/Charts/m-p/348628#M577913 <HTML><HEAD></HEAD><BODY><P>Hi Guys </P><P> i have used only() function in the chart expression&nbsp; but i want that when user clear the selection he should be able to see the total data.??????</P></BODY></HTML> Thu, 12 Apr 2012 09:09:32 GMT https://community.qlik.com/t5/QlikView/Charts/m-p/348628#M577913 2012-04-12T09:09:32Z Charts https://community.qlik.com/t5/QlikView/Charts/m-p/348629#M577914 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using the Aggr() in place of Only().</P><P></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 12 Apr 2012 10:22:02 GMT https://community.qlik.com/t5/QlikView/Charts/m-p/348629#M577914 jagan 2012-04-12T10:22:02Z Charts https://community.qlik.com/t5/QlikView/Charts/m-p/348630#M577915 <HTML><HEAD></HEAD><BODY><P>use max() instead of only()</P><P>regards</P><P>rajni</P></BODY></HTML> Thu, 12 Apr 2012 10:55:20 GMT https://community.qlik.com/t5/QlikView/Charts/m-p/348630#M577915 rajni_batra 2012-04-12T10:55:20Z Re: Charts https://community.qlik.com/t5/QlikView/Charts/m-p/348631#M577916 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use:</P><P></P><P>=if(GetPossibleCount(<STRONG>Field)</STRONG>=Count({1}<STRONG>Field</STRONG>), sum(<STRONG>Expression</STRONG>),sum({$&lt;<STRONG>Field</STRONG>={$(=Only(<STRONG>Field</STRONG>))}&gt;}<STRONG>Expression</STRONG>))</P><P> hope this hepl you</P><P></P><P>Regards,</P><P>Arun Goel</P></BODY></HTML> Fri, 13 Apr 2012 09:59:11 GMT https://community.qlik.com/t5/QlikView/Charts/m-p/348631#M577916 2012-04-13T09:59:11Z