Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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.
I have found that you need a "+" or "*" in your formula
Example: sum({$*[FVSA]} [Transaction Amount])
FVSA is the name of my bookmark
-Brian
Hi Friend,
I am new to set analysis with Bookmark.Please let me know how to use Bookmarks in QV.