topic Re: Bookmarks in QlikView

Bookmarks

Tue, 11 Mar 2014 13:57:48 GMT

Hi all,

With my qlikview application up and running I got a small question about bookmarks.

I need to send a url-link to all employees containing the url for a certain tab and bookmark.

Now i already got this done with this:
....qvw&bookmark=Server\BM144-191&sheet=SH14

However my bookmark contains the selection of a few weeks and divisions, and I need to start sending these url's on weekly/daily basis.

Is it possible that my bookmark will update itself and select week 11/12/13/14/15 instead of me having to make a new bookmark every week.

kind regards

Re: Bookmarks

Anonymous — Tue, 11 Mar 2014 16:43:29 GMT

it will not update by itself,you need to make a new bookmark every week

Re: Bookmarks

Tue, 11 Mar 2014 16:45:06 GMT

Do you just want to automatically select the last couple of weeks or does the week selection vary?

If you do want to select the last few weeks, you can just use the following expression in the advanced search box and then save the bookmark using this, the bookmark will then update dynamically (i.e. the below will select the last 5 weeks loaded)

=aggr(if(rank(Week)<=5,Week),Week)

Re: Bookmarks

Tue, 11 Mar 2014 17:12:04 GMT

Vincent,

As Grace mentionned it, use dynamic bookmarks.

To do,

1) click on the list box, right clic use Advanced Search and enter a dynamic search

2) repeat for other listboxes

3) save your bookmark

Fabrice

Re: Bookmarks

Wed, 12 Mar 2014 08:27:07 GMT

Hi Grace,

I want it to select the first week of the year up to last week (10) atm. With the expression you provided it selects the last 5 weeks of the year.

thank you for helping

Re: Bookmarks

Wed, 12 Mar 2014 09:23:27 GMT

Hi Vincent,

What about using this instead:

Year(Week) = Year(Max( Total Week))

Re: Bookmarks

Wed, 12 Mar 2014 10:28:49 GMT

Hi,

Year(Week) = Year(Max( Total Week))

Doesn't select anything

Re: Bookmarks

Wed, 12 Mar 2014 11:00:42 GMT

I think the week field needs to formatted as a date in order for it to work. Also, make sure to put the equals before it in the advanced search or it won't work so it should be =Year(Week) = Year(Max( Total Week))