topic Re: Is it possible to write a variable value back to a record in a table? in QlikView

Is it possible to write a variable value back to a record in a table?

canoebi99 — Mon, 14 Apr 2014 21:48:36 GMT

Hi all,

I don't think this is possible but thought I would ask the question in case there are any QV wizards out there who might suggest a way to do this!

I have a variable which holds a number value. When the user selects a particular record (i.e. applies a filter down to 1 record only) and then changes this variable I would like to have a button that then writes whatever the value in the variable is back into a field against that record. Essentially updating the data table from the front end of QV.

Is this there a way this could be acheived?

Many thanks

Ben

Re: Is it possible to write a variable value back to a record in a table?

rustyfishbones — Mon, 14 Apr 2014 21:51:51 GMT

Hi Ben,

Do you mean update the Data in the Source database, or updating the Data Table in memory?

Regards

Alan

Re: Is it possible to write a variable value back to a record in a table?

canoebi99 — Mon, 14 Apr 2014 22:19:38 GMT

Hi Alan,

I don't really need to write it back into the database I am reading from. I just need to store it somewhere (and re read it at load time) so probably into a data table in memory that I could then write out a qvd from as the template closes. Or even write a qvd for each value I want to save if that is easier because I could then read them all back in on the load.

Cheers

Ben

Re: Re: Is it possible to write a variable value back to a record in a table?

Mon, 14 Apr 2014 22:27:36 GMT

Example for you.

regards

Darek

Re: Is it possible to write a variable value back to a record in a table?

canoebi99 — Mon, 14 Apr 2014 22:36:54 GMT

Thanks Darek,

This is not quite what I am after, I know how to set the variable. What I want is when I select a record (so in your example say ID 1) and set the variable lets say to 49. I need a button that then stores into a qvd file the ID (1) and Variable Value (49).

If I can do that I can then re read all the stored QVD files back in at load time essentially assigning the value of 49 to the record with an ID of 1 (and any others I have stored).

Cheers

Ben

Re: Is it possible to write a variable value back to a record in a table?

Mon, 14 Apr 2014 22:51:43 GMT

In my example after setting some variable value, start reload.

About your detailed requirements look for information in the subject of "Dynamic Update"

regards

Darek

Re: Is it possible to write a variable value back to a record in a table?

canoebi99 — Mon, 14 Apr 2014 22:56:44 GMT

Thanks Darek,

I see now you are reloading a number of records based on the variable value. I am actually trying to assign the variable value to a single record and store this somewhere so that I can reload the value against that record at a later date.

I appreciate you trying to help me.

Regards

Ben

Re: Re: Is it possible to write a variable value back to a record in a table?

Mon, 14 Apr 2014 23:10:34 GMT

With dynamic update...

Set some new walue on slider and then press xxx button.

You must turn on "Enable Dynamic Data Update" on Document properties/Server

Re: Re: Is it possible to write a variable value back to a record in a table?

Mon, 14 Apr 2014 23:41:20 GMT

And next demo.

Store button should create qvd on your d: drive.

Press Ctrl+M to edit module.

regards

Darek

Re: Is it possible to write a variable value back to a record in a table?

canoebi99 — Mon, 14 Apr 2014 23:46:21 GMT

Many thanks Darek,

I had actually just arrived at this myself and thought I had cracked it. The only issue I now have is that the button to run the macro doesn't seem to work on the server version (it works fine on the desktop version).

I will explore the dynamic update option further as I have never used this.

Do you think there would be any solution to then storing the data out to a qvd file seeing as though I can't run that macro to export the data on the server?

Really appreciate your time!

Cheers

Ben

Re: Is it possible to write a variable value back to a record in a table?

Mon, 14 Apr 2014 23:53:54 GMT

I am sure there is a way

Workaround may be Excel export or start reload in prepared mode, which will reload no data but store your table into qvd.

regards

Darek

Re: Is it possible to write a variable value back to a record in a table?

canoebi99 — Mon, 14 Apr 2014 23:56:37 GMT

Brilliant, thanks Darek,

I will look into everything you have suggested.

Once again thanks so much for your assistance.

Regards

Ben

Re: Is it possible to write a variable value back to a record in a table?

Fri, 05 Dec 2014 06:05:19 GMT

Hi, Alan

Do you know how to write back to memory?

BR/Ting