topic Re: Write back feature in Qlikview in QlikView

Write back feature in Qlikview

psingh206 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlik Experts,

I want to write back some of my processed data to SQL. Let me give you background on the request -

I have insurance claims data. Adjudicators (Medical experts) review claims and flag some claims based on their abuse behavior. Once medical experts flag data. It should be updated in SQL data at backend. In Qlikview, I am thinking to show claims' data in table and it has flexibility for medical experts to select "YES/NO" at each row of the table. Based on their inputs, It should update data in SQL. Also can we have drop down at each row of table?

Re: Write back feature in Qlikview

howiekrauth — Tue, 07 Aug 2018 22:08:17 GMT

Drop Down would be an input box.

Writing back to SQL seems extremely dangerous. We tell our clients we only want read access to their data.

That being said, it can be done (I just tried to be sure).

To do so, once the connection was established, I added:

SQL update <table> SET <field>= 1001 where <field> = 1000;

Re: Write back feature in Qlikview

stefenkauven — Wed, 07 Nov 2018 07:55:53 GMT

Hello,

i have written a Write Back function in the script of a Qlikview-Document

SQL DROP TABLE Tabelle_a;

SQL CREATE TABLE Tabelle_a

(
ID int ,
LocationId int
)
;
Tabelle_b_test:

LOAD table_b.Id as ID,
table_b.LocationId as LocationId

resident table_b;

let vcount = NoOfRows('table_b_test');
let vcounter= 0;

do

Let vID = Peek('ID',$(vCounter), 'table_b_test');

Let vLocationID = Peek('LocationId',$(vcounter),'table_b_test');

SQL INSERT INTO table_a VALUES ('$(vID)','$(vLocationID)');
Let vcounter= $(vcounter)+1
;

loop until $(vcounter)=$(vcount);