topic Data from report to Database(DataSource) in QlikView

Data from report to Database(DataSource)

Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 25 Jul 2017 09:11:37 GMT

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 — Tue, 25 Jul 2017 09:34:50 GMT

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 .

Regards,

Prashant