topic Re: Store InputField values in QVD in QlikView

Store InputField values in QVD

sunitha_chellaiah — Tue, 14 Jul 2020 14:10:58 GMT

Hi All,

I am trying to create a use case. I have used below mentioned script.

Data:
InputField Target;
Load * Inline
[
Region, Target, Actual
North, 100, 200
South, 200, 180
East, 300, 320
West, 400, 410
];

In the front end table, I can able to change the Target values manually.

Now, I want to store the updated table values into QVD after reloading.

Note: I don' t want to use a macro. The updated data must be stored into QVD only after reloading.

Kindly help me to achieve this scenario.

Thanks.

Re: Store InputField values in QVD

Frank_Hartmann — Tue, 14 Jul 2020 15:23:14 GMT

i suppose this is not possible without using a macro!

with macro try like this:

https://community.qlik.com/t5/QlikView-Scripting/Create-and-Save-data-in-Qlikview/td-p/536064

Re: Store InputField values in QVD

sunitha_chellaiah — Tue, 21 Jul 2020 12:44:43 GMT

Hi,

Thanks for your suggestion. I have used macros to achieve my requirement.

The macros are working fine on the QlikView desktop. However, it is not working on the access point.

Is there any way to achieve my requirement through the access point.

Many Thanks!

Re: Store InputField values in QVD

Brett_Bleess — Thu, 23 Jul 2020 14:04:26 GMT

The reason macros will not work using the Ajax client is everything runs server-side in that case, so depending upon what the macro is doing, the user may never see things... What you want to do is not really a functional aspect of the product, probably the only way to accomplish things would be for the users to export things and send that file somewhere that a script can run read those in and create the QVD file etc. I know of no means to do this directly via the server. The key thing to understand about input fields is each user's input is specific to that user...

Regards,
Brett