topic Re: Bookmark based on complex queries in QlikView

Bookmark based on complex queries

Wed, 21 May 2014 20:03:00 GMT

Is it possible to have selection saved in a bookmark that is based on a complex query ?

For instance, I want to select, each day, all sales data for the past 30 days. Is there a way to have a bookmark that will select the data for the last 30 days ?

What alternative solution is there for such a query ?

Best regards

Re: Bookmark based on complex queries

swuehl — Wed, 21 May 2014 20:14:57 GMT

If you use an advanced search in a field instead of selecting just values, a bookmark will save the search and will be as dynamic as your search expression.

Re: Bookmark based on complex queries

Wed, 21 May 2014 20:50:57 GMT

Thanks for your answer! how do i do an advanced search in a field?

Re: Bookmark based on complex queries

hic — Wed, 21 May 2014 21:04:57 GMT

I would instead do it using a relative date, created in the script:

Today() - Date as DaysAgo,

then you can make a selection in this field

And save this in a bookmark. Read more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

HIC

Re: Re: Bookmark based on complex queries

swuehl — Wed, 21 May 2014 21:13:48 GMT

Agree with Henric. This is a nice solution whenever you can create something like a relative date in the script.

Sometimes this might not be easy to do, or you want to create a user bookmark without having the possibility to easily change the script.

Here is an example for a search string that does something similar.

edit: Apply the bookmark from the menu

Re: Bookmark based on complex queries

Thu, 22 May 2014 07:33:10 GMT

Thanks. I can open the document and apply the bookmark. However,, how did you create this bookmark ?

Re: Bookmark based on complex queries

hic — Thu, 22 May 2014 07:37:15 GMT

In Current Selections you can see the search string:

=Date > max(total Date)-10

Just type this in the Date field search box, then save selection as a bookmark.

HIC

Re: Bookmark based on complex queries

Thu, 22 May 2014 07:40:37 GMT

thanks

Re: Bookmark based on complex queries

davidg_curs — Thu, 22 May 2014 11:30:15 GMT

Odsoten sem do 23.05.2014.

Odsoten sem 22.5.2014. Vaše sporočilo bom prebral in nanj po potrebi

odgovoril, ko se vrnem, to je 23.05.2014.

V nujnem primeru v zvezi z QLIKVIEW aplikacijami pa se obrnite na

g.Tekavčič Staneta oz. g.Oven Alojza.

Lep pozdrav

David

Opomba: To je samodejni odgovor na vaše sporočilo "Re: -

Bookmark based on complex queries" poslano naprej 22.5.2014 9:37:54.

To je edino sporočilo, ki ga boste prejeli, ko je oseba odsotna.