topic Re: Get back the InputField (not Input Box) values of a specific Bookmark in QlikView

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

dmohanty — Fri, 04 May 2018 06:42:57 GMT

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.

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.
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 -

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.
I want to reset/remove the last entered values and show the InputField values of a specific Bookmark name.

Any suggestions here?

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

marcus_sommer — Fri, 04 May 2018 07:01:10 GMT

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

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

rubenmarin — Fri, 04 May 2018 07:11:01 GMT

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)

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

dmohanty — Fri, 04 May 2018 07:25:50 GMT

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.

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

dmohanty — Fri, 04 May 2018 07:26:56 GMT

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!

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

dmohanty — Fri, 04 May 2018 07:37:21 GMT

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_*'?

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

rubenmarin — Fri, 04 May 2018 08:04:36 GMT

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.

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

rubenmarin — Fri, 04 May 2018 08:10:13 GMT

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?

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

jafari_ervin — Sun, 28 Oct 2018 14:46:44 GMT

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;