Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sibrulotte
Contributor III

Inputfields and reloads

Hi,

I'm using inputfields that are loaded as such in the script:

INPUTFIELD Commentaires;

INPUTFIELD Confirm;

Load  RowNo() as RowNumber,

VAL_RPT.VAL_DATE &'R_PAI_00200' as %CLE_Date_calcul_NUM_REGLE,

VAL_RPT.VAL_DATE as  Date_calcul,

if(sum(R_PAI_00200.COUNTER)>0,2,0) as Bris,

'R_PAI_00200' as NUM_REGLE ,

'' as Commentaires,

'1' as Confirm

resident VAL_RPT_R230A

group by VAL_RPT.VAL_DATE

;

I write values through a table box.

The values for these two fields have been kept in memory for the past 5 months whenever I reload locally on my machine. I've shared the document with a colleague that has reloaded and values were also kept. But For an unknown reason, he has reloaded yesterday and the values were lost...

I know that if I had loaded these fields from an excel file or any other source that already had values, I would have lost what was written in the table box. But it's not the case. The only thing that could explain this is that the table VAL_RPT_R230A has changed from one load to another and that would trigger Qlikview to lose inputfield values stored in memory. Is that the case?

5 Replies
Highlighted

Re: Inputfields and reloads

Storing from inputfield-values inside a qvw is a fragile matter. I don't know why but it failed quite often and assumedly each time if data-structures and/or the load-order changed (I have had multiple times the case where the inptfield-values were on the wrong record).

Therefore I suggest to export the inputfield-values together with an unique ID or KEY on a regular basis for a backup from which you could load the data again.

- Marcus

shankarece
Honored Contributor

Re: Inputfields and reloads

Simon,

Similar issues discussed here Where and how are input values stored? and input field values lost after reload

Hope it is useful/

dmohanty
Valued Contributor

Re: Inputfields and reloads

Hi marcus_sommer‌,

Any idea how to read the Inputfield values from the .shared files?

I am able to fetch all bookmarks data, but not the inputfield values from .shared file.

Regards,

Dicky

Re: Inputfields and reloads

Hi Dicky

I'm able to find these values with an editor like notepad++ but it would be quite hard to read them in this way. You would need some efforts with reverse engineering to detect the logic how the data are stored.

A lot easier would it be to export the shared-file per shared-file-viewer into a xml-file (option in menu/file) and to read the fieldvalues from there - whereby I'm not sure if this could be automated in any (management API ?) way - maybe there is also (an undocumented) option within the settings.ini like doubling the pgo-files as xml-files.

But this would be only one part of the task - then with them you will get only a list of values like fieldvalues are stored in the symbol-tables and you will need to connect them to the key-field which connects the inputfield with the datamodel to get a useful context them. This will require to load these parts from the qvw-datastructure separate and to match these informations - quite surely not a easy work and it all will take some time.

- Marcus

dmohanty
Valued Contributor

Re: Inputfields and reloads

Hi marcus_sommer‌,

Thank you for the tips here. I am still working on this to get those values, even though that's a pretty herculean task.

Regards.