topic Re: BookMarks in QlikView

BookMarks

rido1421 — Fri, 13 May 2016 12:15:06 GMT

Hi All

is it possible to select all in a book mark and exclude certain selection, but if the dataset updates with new data in that field to include the new data?

If you select the book mark "Correct Models" it will select everything except 325i which is what I selected

but now when the dataset has updated and there is a new row for Bmw 135i I want this to be included in my bookmark selection.

is there a way to allow the book mark to include new data?

Original Data

ItemNo	CarBrand	Model	Value
1	Toyota	Corolla	1000
2	Hyundai	Atos	1500
3	Bmw	325i	5000
4	Bmw	525i	6000

Updated Data:

ItemNo	CarBrand	Model	Value
1	Toyota	Corolla	1000
2	Hyundai	Atos	1500
3	Bmw	325i	5000
4	Bmw	525i	6000
5	Bmw	135i	9000

Re: BookMarks

avinashelite — Fri, 13 May 2016 12:25:42 GMT

qlikview store the Bookmarks a .shared files , One way would be is to read this .shared files using

one of the utilities from Power Tools 1.2 for QlikView to extract the data

You could "Replace" the current bookmark, which is essentially updating it. Just make the selections you want, and from the Bookmarks menu, select "Replace Bookmark", and select the bookmark you want to replace (or update).

Re: BookMarks

rido1421 — Fri, 13 May 2016 12:28:36 GMT

Unfortunately in the real model, there are quite a few selections so redoing the book mark is not an option...

Re: BookMarks

avinashelite — Fri, 13 May 2016 12:30:53 GMT

Did you tried my other suggestion

qlikview store the Bookmarks a .shared files , One way would be is to read this .shared files using

one of the utilities from Power Tools 1.2 for QlikView to extract the data and update it according to the requirement "

Re: BookMarks

tresB — Fri, 13 May 2016 12:32:29 GMT

Check this attached work around. I used a trigger to create the BM. This is one time action after every reload. In desktop version, you can set this action with OnPostReload trigger too.

Re: BookMarks

marcus_sommer — Fri, 13 May 2016 12:34:28 GMT

I think you will need a search-expressions which all dimension-values includes unless those one which you explicit excludes. Here are very good explanations how you could create such search expression/string:

The Expression Search

Compound Search - demystified | Qlik Community

- Marcus

Re: BookMarks

rido1421 — Fri, 13 May 2016 12:51:15 GMT

Hi Tresesco

I think this may work for me, but instead of creating a new book mark I replace the original, otherwise I will end up with many bookmarks for the same selection... I just need to test this some more.

Re: BookMarks

elyM — Fri, 13 May 2016 12:53:30 GMT

HI,

you can apply your selection [Model] field as

=not wildMatch(Model,'325i')

and save it as bookMark.

Regards,

Ely

Re: BookMarks

rido1421 — Fri, 13 May 2016 13:01:46 GMT

Hi Tresesco

I just realized that the users need to be able to recreate the bookmarks if need be.

is there another way to manage the the filters simply maybe on a spreadsheet that can be updated.by the users... ?

Re: BookMarks

rido1421 — Fri, 13 May 2016 13:07:50 GMT

Hi Avinash

unfortunately I am unable to install any other applications based on my environment, so I cant even attempt it...

Re: BookMarks

tresB — Mon, 16 May 2016 05:40:36 GMT

Users can use the created BM to make the default selection, and then make the changes in the selection to suit their default selection and create a BM of their own. This is typically a user-bookmark.