Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Requirement -
Any suggestions here?
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
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:
(check macros 26 and 27)
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.
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!
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_*'?
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.
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?
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;