Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

3 Replies
saumyashah90
Specialist
Specialist

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

marcus_malinow
Partner - Specialist III
Partner - Specialist III

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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