topic Re: Bookmark not working for adhoc report in QlikView

Bookmark not working for adhoc report

saimahasan — Thu, 19 Jan 2017 10:20:57 GMT

Hi All,

I need to create and use bookmarks for my adhoc report. But when i view the bookmark it shows some other selections with error : Error: error in expression.

Please suggest.

Re: Bookmark not working for adhoc report

avinashelite — Thu, 19 Jan 2017 10:37:45 GMT

have you changed the data model ??

Re: Bookmark not working for adhoc report

saimahasan — Thu, 19 Jan 2017 11:53:37 GMT

No i have just added the dimension and measure tables. Rest its same. Bookmarks are working for other charts but not working only for adhoc

Re: Bookmark not working for adhoc report

avinashelite — Thu, 19 Jan 2017 12:22:52 GMT

new dimension in the script or UI ...can you will with an example

Re: Bookmark not working for adhoc report

saimahasan — Thu, 19 Jan 2017 12:27:34 GMT

I have created an excel with Dimensions and Measures. Loaded it in my data model and created my adhoc report. Now when i select anything in the adhoc report and mark it as bookmark, it does not give me the selected values when i reuse that bookmark.

Re: Bookmark not working for adhoc report

avinashelite — Thu, 19 Jan 2017 12:35:43 GMT

I checked the its working for me..

Check this things once.

1.Make all the selections and go to bookmarks

2.In the Bookmarks option > select Include selections in Bookmarks

3.Check all the necessary things and one more thing if you had any single select in any list box retain that

if still it did not work , share the app let me check once

Re: Bookmark not working for adhoc report

saimahasan — Sat, 21 Jan 2017 10:24:55 GMT

Please find attached the sample file for bookmarks and the error i am getting.

Please suggest.

In this when you select any bookmark it shows author_name as default selection in current selection box.

Re: Bookmark not working for adhoc report

avinashelite — Mon, 23 Jan 2017 08:31:35 GMT

Got the issue , this bookmark is working fine ...

because you have used the on filed event Trigger =If(GetFieldSelections(customer_first_name)='Franklin',' ')

Go to document properties >Triggers > check the filed Event Trigger > customer_first_name

Re: Bookmark not working for adhoc report

saimahasan — Mon, 23 Jan 2017 10:51:22 GMT

Yes i have applied that trigger because i need it. My requirement is the same. I need to clear some fields on triggers and also use bookmarks. Please suggest

Re: Bookmark not working for adhoc report

saimahasan — Mon, 23 Jan 2017 10:53:29 GMT

Can we use alternate states in this scenario??

Re: Bookmark not working for adhoc report

avinashelite — Mon, 23 Jan 2017 11:10:05 GMT

No , Alternate state does,'t solve the problem here ..we need to read the whether their are any active bookmarks or not and based on that we need to trigger the filed event

check this tread and get whether bookmark is active or not based on the trigger the field event

Is it possible to hold bookmark name in variable?

Hope this helps you