Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps with something like this: Write back to database via XML output or web service
Perhaps with something like this: Write back to database via XML output or web service
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?
also see
thanks all theres plenty for me to get started with.
thanks all for the rapid replies