topic Re: looking for the correct syntax : bookmarks + set analysis in QlikView https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445488#M166184 <HTML><HEAD></HEAD><BODY><P>ofcourse .. i'm using now the expression you mentioned. Tnx</P></BODY></HTML> Thu, 27 Sep 2012 20:02:50 GMT amien 2012-09-27T20:02:50Z looking for the correct syntax : bookmarks + set analysis https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445486#M166182 <HTML><HEAD></HEAD><BODY><P class="p1">sum({&lt;Region = {East},Customer_Enabled = {1}&gt;} Sales)</P><P class="p1"></P><P class="p1">I have a bookmark with a few customers selected. Now i want above results but WITHOUT the customers that are in the bookmark:</P><P class="p1"></P><P class="p1">sum({-ExcludedCustomersVolume &lt;Region = {East},Customer_Enabled = {1}&gt;} Sales)</P><P class="p1"></P><P class="p1">is not working</P><P class="p1"></P><DIV> </DIV><P></P></BODY></HTML> Wed, 26 Sep 2012 15:19:52 GMT https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445486#M166182 amien 2012-09-26T15:19:52Z Re: looking for the correct syntax : bookmarks + set analysis https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445487#M166183 <HTML><HEAD></HEAD><BODY><P>If ExcludedCustomersVolume is you bookmark name, I think the syntax is a correct syntax, if you want to exclude your bookmark modified with given set modifiers from the total record set.</P><P></P><P>If you want to just exclude your bookmarked Customers from the first set, try</P><P></P><P class="p1"><EM>=sum({&lt;Region = {East},Customer_Enabled = {1}&gt;-ExcludedCustomersVolume} Sales)</EM></P></BODY></HTML> Wed, 26 Sep 2012 16:09:14 GMT https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445487#M166183 swuehl 2012-09-26T16:09:14Z Re: looking for the correct syntax : bookmarks + set analysis https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445488#M166184 <HTML><HEAD></HEAD><BODY><P>ofcourse .. i'm using now the expression you mentioned. Tnx</P></BODY></HTML> Thu, 27 Sep 2012 20:02:50 GMT https://community.qlik.com/t5/QlikView/looking-for-the-correct-syntax-bookmarks-set-analysis/m-p/445488#M166184 amien 2012-09-27T20:02:50Z