Get back the InputField (not Input Box) values of a specific Bookmark

[dmohanty]

Hi All,

This is related to the behavior of the InputFields (not Input Box/variables) in QlikView.

As per QlikView, Input fields normally retain their previously set value after a reload.

1. I entered some values in InputFields and created a Bookmark called 'MyFavorite_*'  [* could be anything]. So the InputField values are available in the module/report,even after multiple reloads, as long as any new values are not entered in the InputField.
2. After sometime, I changed values in InputFields and created any other random bookmark. Now the InputFields have the latest input values based on user and the value entered for previous bookmark are gone. (Qlik Feature).

Requirement -

1. If I open the report in any day/time, the InputField should show the values of the specific created bookmark - 'MyFavorite_*', and not the last entered values.
2. I want to reset/remove the last entered values and show the InputField values of a specific Bookmark name.

Any suggestions here?

[marcus_sommer]

I'm not sure but I believe that InputFields aren't really feasible for advanced approaches of entering data into Qlik and to store them persistent. Therefore I think that any writing approaches into a database would be more suitable. You could try it with something like this: SQL Writeback from QlikView extension object. but there are also various commercial tools available.

- Marcus

[rubenmarin]

Hi Dicky, as per my knowledge Input fields are not selections, selections are made on field values, input fields changes the values, no select them.

The only way I know to edit this values in design is through macros:

Useful Qlikview Macros

(check macros 26 and 27)

[dmohanty]

Hi rubenmarin,

I understand that InputFields are not selections and they are just user input values. Using those values I have created some bookmarks. and I can apply the bookmarks and those are working fine too.

Qlik reports displays the Last entered User Input Field values when a QVW is opened from the Access Point.

But, I want to retrieve back the InputField values that have entered for a specific bookmark, NOT the last entered bookmark.

[dmohanty]

Hi marcus_sommer

Thank you for guiding.

This piece of the design could be hard now to implement in an already running application. But as a practice, I would give that a try.

Regards!

[dmohanty]

rubenmarin‌

I looked at the Macros and in one application I am using to Reset the Input Fields back to Zero (No. 26 from the list).

But taking reference of No.27, can be Set the Input Fields to the values WHERE the Bookmark Name = 'MyFavorite_*'?

[rubenmarin]

I reviewed the question and I'm not sure to understand the issue...

1. There is a bookmark with input field values -> BM01

2. Another bookmark is created with input field values -> BM02

Setting a trigger OnOpen that applies the BM01 bookmark can work? Or adding a button that resets (applies the bookmark) to reset values.

[rubenmarin]

I don't know if using macros you can iterate thorugh stored values, either if you can set individual values for input field relations.

Mainly in will be to reset values to initial values, and for that the initial loaded values should be the ones you want. Loading them from an external source can be an option?

[jafari_ervin]

end user should right click on the input column in the table then select  RestoreValue ->Restore All Value;

if you comment or not execute the input field command in your script then all your value reset, then for this purpose please set the if statement for your input field like below then create two job in qlikview server depend on another. first with passing 1 and second with passing 0 (in Reload Tab -> Passing Parameter);

if('$(v_ReloadType)'=1) then   

INPUTFIELD inputfield1;

end if;