Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

looking for the correct syntax : bookmarks + set analysis

sum({<Region = {East},Customer_Enabled = {1}>} Sales)

I have a bookmark with a few customers selected. Now i want above results but WITHOUT the customers that are in the bookmark:

sum({-ExcludedCustomersVolume <Region = {East},Customer_Enabled = {1}>} Sales)

is not working

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

If you want to just exclude your bookmarked Customers from the first set, try

=sum({<Region = {East},Customer_Enabled = {1}>-ExcludedCustomersVolume} Sales)

View solution in original post

2 Replies
swuehl
MVP
MVP

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.

If you want to just exclude your bookmarked Customers from the first set, try

=sum({<Region = {East},Customer_Enabled = {1}>-ExcludedCustomersVolume} Sales)

amien
Specialist
Specialist
Author

ofcourse .. i'm using now the expression you mentioned. Tnx