topic Re: expression sum query in QlikView https://community.qlik.com/t5/QlikView/expression-sum-query/m-p/420556#M484957 <HTML><HEAD></HEAD><BODY><P>Enclose string values in single quotes. Use -= for <EM>not</EM>.</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">sum({&lt;entity={'asia'},category -= {'public'}&gt;}[GBP value])</SPAN></P></BODY></HTML> Thu, 02 May 2013 12:45:15 GMT Gysbert_Wassenaar 2013-05-02T12:45:15Z expression sum query https://community.qlik.com/t5/QlikView/expression-sum-query/m-p/420555#M484956 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>while we wirte teh below expression, can we write not equal to :</P><P></P><P>= sum({&lt;entity={asia},category&lt;&gt;{public}&gt;}[GBP value])</P><P></P><P></P><P>this is not working as in category i have values (public, private and open) but new categories will keep coming so how to sum all excluding Public Category</P><P></P><P>thanks</P></BODY></HTML> Thu, 02 May 2013 12:38:56 GMT https://community.qlik.com/t5/QlikView/expression-sum-query/m-p/420555#M484956 2013-05-02T12:38:56Z Re: expression sum query https://community.qlik.com/t5/QlikView/expression-sum-query/m-p/420556#M484957 <HTML><HEAD></HEAD><BODY><P>Enclose string values in single quotes. Use -= for <EM>not</EM>.</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">sum({&lt;entity={'asia'},category -= {'public'}&gt;}[GBP value])</SPAN></P></BODY></HTML> Thu, 02 May 2013 12:45:15 GMT https://community.qlik.com/t5/QlikView/expression-sum-query/m-p/420556#M484957 Gysbert_Wassenaar 2013-05-02T12:45:15Z