topic InputField in QlikView

InputField

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community,

Im using on my model whit InputField the problem is that i cant rest the data on the field every time i make reload to the original data that came from the data source.

p.s my client dont want duplicate field ex (Original Field and InputField )

Can anyone have idea for me how can i do this ?

Thanks

David.

Re: InputField

Gysbert_Wassenaar — Tue, 10 May 2016 07:26:35 GMT

You'll have to reload the document twice. The first time you immediately exit the script so the document is reloaded without data. This will also clear the persistent input field values. Then the next reload loads the original date from the excel file. You can pass a variable value as parameter with the command line options: qv.exe /r /vvClear=1 MyDoc.qvw. That way you can create a batch script that will reload the document twice and clear the data on the first run.

IF vClear=1 THEN
set vClear=0;
exit script;
ENDIF

INPUTFIELD HaderaQty;

Data:
LOAD
     Country,
     Supplier,
     S.Terms,
     C.Status,
     HaderaQty,
     HaderaQty As H.Qty
FROM
      datafields.xlsx
      (ooxml, embedded labels, table is Simulation)
      ;

Re: InputField

moleroalonso — Tue, 10 May 2016 07:53:42 GMT

You can use a macro like this:

Sub ResetInputField

' Reset the InputField

set fld = ActiveDocument.Fields("HaderaQty")

fld.ResetInputFieldValues 0, 0 ' 0 = All values reset, 1 = Reset Possible value, 2 = Reset single value

End Sub

Macro extracted from: Useful Qlikview Macros

Re: InputField

Anonymous — Tue, 10 May 2016 10:54:47 GMT

Thank you but i didn't understand how to do this, i need every reload reset my data

Re: InputField

Gysbert_Wassenaar — Tue, 10 May 2016 10:59:59 GMT

Yes, I understood you. And my answer is that you need to reload that document twice each time you want to reset the inputfield values and load the original date. The first reload is done with a variable vClear set to 1 so the script excecution is terminated in the IF-ENDIF block. The document will then be saved without data. The persistent inputfield values will be cleared too. A regular reload won't do this. That is why you need this first reload. Then the second reload directly after the first will load the data from the excel file and effectively reset the input field values. See attached example.

Re: InputField

Anonymous — Tue, 10 May 2016 13:11:53 GMT

Thank you for your help i wish i could do it on one reload,

My app is connected to sql server and i do reload one time in a day on qlikview server and this need to be manually

Re: InputField

Gysbert_Wassenaar — Tue, 10 May 2016 15:17:29 GMT

That depends. If you have Publisher you can schedule two tasks for the same document. If you don't have Publisher you could use a batch file to reload the document twice using a Windows scheduled task.

Re: InputField

Anonymous — Wed, 11 May 2016 05:09:10 GMT

Thank you so much this is work perfect as i wanted !!! *****

Re: InputField

Anonymous — Wed, 11 May 2016 05:14:20 GMT

If i want more then one field what will be the syntax at the macro And to change field whit 0 value ?

Re: InputField

ancient_grape — Fri, 15 Jan 2021 21:09:37 GMT

I know this thread is ancient, but I just wanted to say thank you for this solution as it saved my life.

I was tearing my hair out due to the "reset values" bug that still exists in 11.20 SR20 (which causes zero-byte files to be saved after resetting inputfield values) and was looking for a solution to help my users.

Your "double-reload" solution did the trick exactly - thank you again!