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: 
psingh206
Contributor
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
howiekrauth
Partner - Contributor III
Partner - Contributor III

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
Contributor III
Contributor III

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