topic Re: Bookmarks not holding Input Value in QlikView

Bookmarks not holding Input Value

tmumaw — Thu, 05 Jun 2014 12:40:42 GMT

Good morning everyone,

Having a problem setting bookmarks. I have a "What If" model which allows users to enter different percentages on multiple lines. After they have entered all of their percentages they want to save it as a bookmark. Well there are lines A - L. Here is what gets entered by the user, then they save the bookmark and then open the model and access the bookmark and they get the Return values. Any ideas?

A 36%      Returns 36%
B 3%        Returns 4%     (wrong)
C 33%      Returns 33%
D 5%        Returns 5%
E 30%      Returns 30%
F 20%      Returns 0%     (wrong)
G 15%      Returns 15%
H 0%        Returns 0%
I 0%         Returns 0%
J 7%        Returns 7%
K 7%       Returns 7%
L 9%        Returns 9%

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 12:43:39 GMT

Could you share a sample qvw? the bookmark should hold true

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 12:45:20 GMT

When you create the bookmark select "Include Input Values"

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 12:46:14 GMT

Score one for Jake, if that doesn't work then the qvw would be helpful haha

Re: Bookmarks not holding Input Value

tmumaw — Thu, 05 Jun 2014 12:48:07 GMT

I did Jacob. Not too easy to include model. It's sensitive financial and payroll data.

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 12:50:31 GMT

I'm unsure I follow, A-L are your input fields. Where are the return values coming from?

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 12:50:37 GMT

Do you use variables to store any of the values?

http://www.resultdata.com/qlikview-updating-variables-in-bookmarks/

Re: Bookmarks not holding Input Value

tmumaw — Thu, 05 Jun 2014 12:53:30 GMT

The user saves the bookmark with the % entered and then re-accesses the model and selects the saved bookmark and that is what gets returned.

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 12:57:44 GMT

If your inputfields are holding variables, make sure you go to Settings -> Document Properties -> Variables -> Include in Bookmarks.

Re: Bookmarks not holding Input Value

tmumaw — Thu, 05 Jun 2014 14:41:32 GMT

Did as you said Jacob and got the same results

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 14:46:31 GMT

http://community.qlik.com/thread/74220

From the above thread:

"The values entered in the input box are usually assigned to variables and qlikview saves only the information about server objects, and not the data itself, in the .shared files .

If you'd want to save the data for future use; you'd have to write a macro to save the input data to some file and read from it while relaoding the document. so that all the inputs values are available for use in the UI"

If you could upload your qvw that would be helpful.

Re: Bookmarks not holding Input Value

Thu, 05 Jun 2014 14:47:52 GMT

Even if you can't post your actual qvw due to the sensitive info, if you could post a sample qvw with the error that would be helpful

Re: Bookmarks not holding Input Value

tmumaw — Fri, 06 Jun 2014 17:35:43 GMT

For some reason my variable were not showing up on the list of variables to set as bookmark. I deleted them and re-added, deleted everything from Accesspoints, reloaded and it appears to be working. Thanks everyone for your help.