topic Re: Expression Help in QlikView https://community.qlik.com/t5/QlikView/Expression-Help/m-p/426570#M158936 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I think you should do it in the script instead of chart</P><P></P><P>Create 2 tables for chrono 6 and chrono 7</P><P></P><P>Load Student , score&nbsp; as score6&nbsp; from resident yourTable</P><P>&nbsp; group by score&nbsp; </P><P>Where chrono = 6 ;</P><P></P><P>Idem for chrono 7</P><P></P><P>Then create a chart like this</P><P></P><P>Sum (&nbsp; if( score7 &gt; score6 , 1 , 0) )</P><P></P><P>JJ</P></BODY></HTML> Mon, 12 Nov 2012 21:24:43 GMT 2012-11-12T21:24:43Z Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/426569#M158935 <HTML><HEAD></HEAD><BODY><P>Hi everyone, could anyone help me with this please?</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/message/280378#280378">http://community.qlik.com/message/280378#280378</A></P></BODY></HTML> Mon, 12 Nov 2012 21:03:25 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/426569#M158935 2012-11-12T21:03:25Z Re: Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/426570#M158936 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I think you should do it in the script instead of chart</P><P></P><P>Create 2 tables for chrono 6 and chrono 7</P><P></P><P>Load Student , score&nbsp; as score6&nbsp; from resident yourTable</P><P>&nbsp; group by score&nbsp; </P><P>Where chrono = 6 ;</P><P></P><P>Idem for chrono 7</P><P></P><P>Then create a chart like this</P><P></P><P>Sum (&nbsp; if( score7 &gt; score6 , 1 , 0) )</P><P></P><P>JJ</P></BODY></HTML> Mon, 12 Nov 2012 21:24:43 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/426570#M158936 2012-11-12T21:24:43Z