Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

psingh206
New Contributor

Write back feature in Qlikview

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?

2 Replies
Partner
Partner

Re: Write back feature in Qlikview

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;

stefenkauven
New Contributor II

Re: Write back feature in Qlikview

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);