topic edit expression in QlikView https://community.qlik.com/t5/QlikView/edit-expression/m-p/256584#M97059 <HTML><HEAD></HEAD><BODY><P>use the below code</P><P>sum({&lt;Directorate = <STRONG>{"</STRONG>Surgical Services<STRONG>"}</STRONG>&gt;}[planned activity] <STRONG>)</STRONG></P></BODY></HTML> Fri, 25 Nov 2011 15:24:21 GMT SunilChauhan 2011-11-25T15:24:21Z edit expression https://community.qlik.com/t5/QlikView/edit-expression/m-p/256581#M97056 <HTML><HEAD></HEAD><BODY><P>Please could someone please help.&nbsp;&nbsp; What's the wrong with this expression </P><P></P><P>=sum({&lt;Directorate = 'Surgical Services'&gt;}[planned activity]</P></BODY></HTML> Fri, 25 Nov 2011 14:57:49 GMT https://community.qlik.com/t5/QlikView/edit-expression/m-p/256581#M97056 2011-11-25T14:57:49Z Re: edit expression https://community.qlik.com/t5/QlikView/edit-expression/m-p/256582#M97057 <HTML><HEAD></HEAD><BODY><P>You are missing a right paren at the end of the expression.</P><P></P><P>=sum({&lt;Directorate = 'Surgical Services'&gt;}[planned activity] <STRONG>)</STRONG></P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></P></BODY></HTML> Fri, 25 Nov 2011 15:06:53 GMT https://community.qlik.com/t5/QlikView/edit-expression/m-p/256582#M97057 rwunderlich 2011-11-25T15:06:53Z edit expression https://community.qlik.com/t5/QlikView/edit-expression/m-p/256583#M97058 <HTML><HEAD></HEAD><BODY><P>oops sorry Rob i do have the left ) just didn't post it correctly on the discussion. </P><P>could u think of anything else because expression is ok but not getting a result for some reason</P><P></P><P>Thanks </P></BODY></HTML> Fri, 25 Nov 2011 15:15:43 GMT https://community.qlik.com/t5/QlikView/edit-expression/m-p/256583#M97058 2011-11-25T15:15:43Z edit expression https://community.qlik.com/t5/QlikView/edit-expression/m-p/256584#M97059 <HTML><HEAD></HEAD><BODY><P>use the below code</P><P>sum({&lt;Directorate = <STRONG>{"</STRONG>Surgical Services<STRONG>"}</STRONG>&gt;}[planned activity] <STRONG>)</STRONG></P></BODY></HTML> Fri, 25 Nov 2011 15:24:21 GMT https://community.qlik.com/t5/QlikView/edit-expression/m-p/256584#M97059 SunilChauhan 2011-11-25T15:24:21Z