topic Re: Inputfields and reloads in QlikView

Inputfields and reloads

sibrulotte — Fri, 03 Jul 2015 14:51:29 GMT

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?

Re: Inputfields and reloads

marcus_sommer — Fri, 03 Jul 2015 17:41:52 GMT

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

Re: Inputfields and reloads

Siva_Sankar — Mon, 06 Jul 2015 07:13:14 GMT

Simon,

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

Hope it is useful/

Re: Inputfields and reloads

dmohanty — Wed, 07 Dec 2016 18:36:04 GMT

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

marcus_sommer — Thu, 08 Dec 2016 08:36:56 GMT

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

Re: Inputfields and reloads

dmohanty — Fri, 09 Dec 2016 15:33:47 GMT

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.