Combining Document Bookmarks with Set Modifiers

Mon, 23 Nov 2009 17:13:10 GMT

Hi,

for a current product I am trying to combine a document bookmark with a set modifier.

I have a Bookmark called BM1, and I would like to get a sum of a variable, but restrain all selections to BM1, with one field (Customer) fixed to a certain value (using a set modifier).

I would have assumed the syntax looked something like this:

sum({BM1 <Customer=1>} variable)

Unfortunately this does not seem to have any effect.

Playing around with set functions like * only gave me the intersection between the current selection (limited according to the set modifier) and the bookmark. That's not what I am looking for.

I need the exact selections of the bookmark, only with one field set to a different value.

Any help would be appreciated!

topic Combining Document Bookmarks with Set Modifiers in QlikView

Combining Document Bookmarks with Set Modifiers