topic Re: A button to change a value in a database in QlikView

A button to change a value in a database

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

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.

Kushal_Chawda — Tue, 12 Apr 2016 10:48:20 GMT

see this

Gysbert_Wassenaar — Tue, 12 Apr 2016 10:48:53 GMT

amit_saini — Tue, 12 Apr 2016 10:49:30 GMT

Hi,

Check:

Thanks,

samuel_brierley — Tue, 12 Apr 2016 10:49:47 GMT

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 — Tue, 12 Apr 2016 10:51:22 GMT

Hi,

may help you

Kushal_Chawda — Tue, 12 Apr 2016 10:51:42 GMT

also see

samuel_brierley — Tue, 12 Apr 2016 10:51:46 GMT

thanks all theres plenty for me to get started with.

thanks all for the rapid replies