topic Using a bookmark in Set Analysis in QlikView

Using a bookmark in Set Analysis

Mon, 07 Sep 2009 16:24:28 GMT

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??

Using a bookmark in Set Analysis

Mon, 07 Sep 2009 20:53:45 GMT

In my application it works with count too.

Maybe you could try: =count({MyBookMark}Sales)

Using a bookmark in Set Analysis

Mon, 07 Sep 2009 22:41:41 GMT

Hi,

... count together with set analysis and bookmarks definitely works; I am using it in some applications ...

Best regards

Stefan

Using a bookmark in Set Analysis

Tue, 08 Sep 2009 16:26:19 GMT

Maybe its the Dimensions i'm using or something, still isn't working, i'll work it out, just seeing if anyone else has the same problem because it is very simple in set analysis and would help out alot if it did work.. Thanks for the input..

Using a bookmark in Set Analysis

Tue, 08 Sep 2009 19:42:47 GMT

Are you using the file local or via QlikView server?

In a recent project I had problems adressing the ID of the bookmark correctly when using bookmarks & set-analysis together ...

Best regards
Stefan

Using a bookmark in Set Analysis

Thu, 10 Sep 2009 15:07:56 GMT

Local... Will that have an effect on anything??

Using a bookmark in Set Analysis

Thu, 10 Sep 2009 16:14:39 GMT

I tried it local and it works (version 9.0).

Using a bookmark in Set Analysis

Anonymous — Thu, 10 Sep 2009 16:46:36 GMT

This is a real longshot but if you have QV Developer 8.50 SR3 or earlier (8.50.6231) there was a bug with Set Analysis and bookmarks that were based on searches. If you created a bookmark that was based on a search, for example Age > 35, then the Set Analysis expression would ignore the bookmark selection and give the full count.

In more recent versions it should work just fine as stated by others in this thread.

Using a bookmark in Set Analysis

Fri, 11 Sep 2009 20:00:38 GMT

Sorry for the late reply, i'm currently using 8.5.. No i dont use a search in the expression at all i simply put

count({Bookmark}UserID)

and it comes up as if i've put

count(UserID)

I don't know what the problem is, has there been any problems like this before??

Using a bookmark in Set Analysis

Fri, 11 Sep 2009 20:14:15 GMT

I have just tested set analysis with bookmarks on two versions:

8.50.626.1.5

and

9.00.7199.4

Works fine!. See attached example.

Maybe post your file here so we can have a look???

Cheers

Karol

Using a bookmark in Set Analysis

johnw — Sat, 12 Sep 2009 01:53:48 GMT

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.

Using a bookmark in Set Analysis

Anonymous — Sat, 12 Sep 2009 02:31:39 GMT

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

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

FVSA is the name of my bookmark

-Brian

Using a bookmark in Set Analysis

Fri, 26 Feb 2010 07:15:53 GMT

Hi Friend,

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