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: 
samuel_brierley
Creator
Creator

A button to change a value in a database

Hi all,

i understand that Qlikview is a visualization tool but im pre-empting a question from a client and want the answer before hand.....

we have an oracle database that brings in data and set various signals e.g switch this light on when this happen, that kind of thing.

ive built a qlikview dashbaord for it and all is well however the client is going to ask me if i can switch the light on using QlikView.

the action really is as simple as.... in SQL

UPDATE [Assets] SET [VALUES] = 2 WHERE [Asset ID] = 'ABC'

which will set the value to 2 for Asset ABC in the Assets table. this will switch on the light.

I was thinking is it possible to use either:

1. attach an SQL statement to the button that will insert the value required to switch on the light.

2. use  a rest api in an extension object (will need alot of help this way i think)

thanks all,

i realise QlikView isnt built for this however im sure these requirements have a use.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps with something like this: Write back to database via XML output or web service


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gysbert_Wassenaar

Perhaps with something like this: Write back to database via XML output or web service


talk is cheap, supply exceeds demand
amit_saini
Master III
Master III

samuel_brierley
Creator
Creator
Author

Hi thanks fr the rapid reply.

it was my understanding that Dynamic Update only changes the values in the loaded tables and not the source database? is this not the case?

kkkumar82
Specialist III
Specialist III

samuel_brierley
Creator
Creator
Author

thanks all theres plenty for me to get started with.

thanks all for the rapid replies