Data from report to Database(DataSource)

[#1]

HI ,

I am new to QlikView. I had a scenario how to load inserted/updated data of a report to a database.

Example I have data like in the data base table as

ID, Month, Year, SalesPerson, Sales
1, Jan, 2014, Jack, 10000
2, Jan, 2014, John, 12000

say I have updated the data in the report for John to 15000 then the data should be as below in the data base as well as in the report

1, Jan, 2014, Jack, 10000

2, Jan, 2014, John, 15000

Is this possible?

Is there a way to enter/update data in Qlik report?

Thanks in Advance.

[jmvilaplanap]

Hi,

If the data is refreshed in the datasource, you only have to reload the qlik app.

If is necessary, you can create a small excel or csv with corrections and load it with the rest of the data.

Regards

[PrashantSangle]

Hi,

Qlikview dont recommend to write back to database . but if you still required then using macro you can achieve it.

go through below threads .

https://community.qlik.com/search.jspa?q=write+back+to+database‌

Regards,

Prashant