Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using a bookmark in Set Analysis

Hi,

I've been trying to use bookmarks in Set analysis to simplify the formula and because it seems alot more economical, i tried using examples from the Qlikview reference manual:





sum(

{MyBookMark} Sales) - returns sales for the bookmark MyBookMark.

I've tried this method, except i've used 'count' instead of 'sum', it doesnt work at all, just returns the same as 'Count(FieldName)' . Does it not work on count?? or is the example superficial, is there another way of doing it??



12 Replies
johnw
Champion III
Champion III

Set analysis works fine with document workmarks. It doesn't work for me with user bookmarks, and I'm told it doesn't work at all with user bookmarks, only document and server bookmarks. Are you using user bookmarks? If so, that would explain your results.

Anonymous
Not applicable
Author

I have found that you need a "+" or "*" in your formula

Example: sum({$*[FVSA]} [Transaction Amount])

FVSA is the name of my bookmark

-Brian

Not applicable
Author

Hi Friend,

I am new to set analysis with Bookmark.Please let me know how to use Bookmarks in QV.