topic Is there a way to write data back to the source using QV ? in QlikView

Is there a way to write data back to the source using QV ?

Thu, 10 Oct 2013 10:58:32 GMT

Hi All,

Is there a way to write data back to the Source (DB/Excel/Flat files) using QV ?

Consider the below scenario for example :

***********************************************************************************

I am using the QlikView to show reports to the client on the bonus percentage for each department in an organization.

Bonus is a column in the source.

Now if the user wishes to reduce or increase the bonus to some extent (adjustments) then he should type the new bonus amount in QlikView and the same should also be reflected in the source.

This source will be again used by the payroll team to generate salary...

***********************************************************************************

Is this possible using QV ?.

I am using 11 SR2.

Re: Is there a way to write data back to the source using QV ?

saumyashah90 — Thu, 10 Oct 2013 11:01:40 GMT

yes you have an option for that...

yo can get an alert and

you can also mail to a given email id when it reaches to some extent

Re: Is there a way to write data back to the source using QV ?

marcus_malinow — Thu, 10 Oct 2013 11:15:12 GMT

Sanjeev,

I don't believe this is possible using QlikView, however there's an extension object, KliqPlan, which is designed to do this.

KliqPlan (Planning Suite)

Marcus

Re: Is there a way to write data back to the source using QV ?

Peter_Cammaert — Thu, 10 Oct 2013 12:30:51 GMT

Writing back values to your data source is perfectly possible in QlikView, but only:

in the load script. This more or less makes it unusable for your purpose
if you enable "Open Databases in Read and Write mode" in the script editor settings tab.
using SQL For example, SQL UPDATE allows you to write back updated values to a table.
IMHO there is no comparable QlikView script statement.

Best,

Peter