Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvillar3589
Contributor II
Contributor II

Help! How can I reset a Vizlib Input Form with the click of a button? (Using variable as the Destination)

Hello all,

Could desperately use some advice!!

I am working with a Vizlib Input Form and have set the writeback settings to writeback the inputs as a variable as a destination instead of a qvd or server. Each of my input fields in the form have a variable and also a field name(but i dont think the field name matters in this case). I have created the variables in the lower left hand corner of the qlik sheet and left all of their expressions as blank(ex: vSales = nothing in expression field) and there is a different variable bound to every single input field(some are text input, numeric input, dropdown, radio button, checkbox etc).

So upon clicking 'Submit', the form saves all the inputs as variables. I have a button that navigates me to another sheet with a separate writeback table that populates with the inputs from the form via partial load and then I make some edits in THAT writeback table and click submit and the table is written into a qvd.

 

THE PROBLEM: When I navigate BACK to the original Input Form, the inputs are still the same as the last entry. I have tried setting the variables as blank, '', null() upon clicking any button that navigates away from the input form so that it clears out the form but even when I check by viewing the variable value in a text/image box and can SEE the variable has been cleared, the form remains filled out with the original inputs.

Can anyone help me with this? I must find a way to reset the form without having to click 'Reset Form' button every time. Very much need to find a solution to this soon and any help is greatly appreciated!!

 

 

0 Replies