Discussion Board for collaboration related to QlikView App Development.
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)
i realise QlikView isnt built for this however im sure these requirements have a use.
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?