topic Re: Dynamic value update of the inputbox in QlikView

Dynamic value update of the inputbox

nitin_bajpai — Mon, 13 Apr 2015 06:09:25 GMT

Hi freinds,

We have an reuirement to update an value of input box (basically comments so free text) in one of my tablebox in QVW.

What should be the best methodology which i should follow . I have gone through below docs but is there any better way where i can update the comments by pining it back to some constantly saved data file or DB via XML. Current options i have explore are but looking for some method which can be implemented on big scale and with better clear steps as i am new to this :

a. Free Text Box Extension Object

b.Write back to database via XML output or web service

looking forword for help from you all as this is very urgent requirement. Thanks in advance

Re: Dynamic value update of the inputbox

Colin-Albert — Mon, 13 Apr 2015 14:59:39 GMT

If you need to comment your charts or data, you could use the Notes functionality in QV11 Server

Implementing Annotations and Collaberations in Qlikview

or have a look at this thread. Re: Re: Notes in QlikView

Re: Dynamic value update of the inputbox

nitin_bajpai — Tue, 14 Apr 2015 04:22:51 GMT

hi colin,

Thanks a lot for your input, actually i am looking for some funtionality in which for a certail account and its details we want to have one of the coloumn in table box i.e. comment and that can be updated by users (multiple times) and every time is is updated it should be refreshed.

Is there any methodology where i can send back the changed value (after converting it to XML and send via web services) and store it in some files , from which i can load again via direct discovery ...

If someone has implemented any funtionanlity like this can you please help .....

thanks a lot ...

Re: Dynamic value update of the inputbox

Anonymous — Tue, 14 Apr 2015 05:57:16 GMT

are you specific to xml or database will also work ..?

Re: Dynamic value update of the inputbox

Anonymous — Tue, 14 Apr 2015 06:04:47 GMT

Hi Nitin,

I recently implemented dynamic update for one of the my project.

where i am taking input in textboxes and same time updating those value in my aap as well as databse using macro .

you can see below links. for xml ..let me knwo if you need any help on this .

Re: QlikView Commenting with Dynamic Update (no extension needed)

these settings you need to change-

Dynamic Update - Simple Database

Thanks

BKC

Re: Dynamic value update of the inputbox

nitin_bajpai — Tue, 14 Apr 2015 06:21:01 GMT

Thanks a lot bro ..will try to implemenet and get back to you incase need any more help.

Re: Dynamic value update of the inputbox

nitin_bajpai — Tue, 14 Apr 2015 06:30:47 GMT

The requiremnet is preferably to some XML,CSV or txt file rather than DB .. is it possible ?

Re: Dynamic value update of the inputbox

Anonymous — Tue, 14 Apr 2015 10:00:24 GMT

Yes its possible

Re: Dynamic value update of the inputbox

nitin_bajpai — Tue, 14 Apr 2015 10:32:30 GMT

can you please help to explain how we can achieve that ..thanks in advance ..

my email address is nitinbajpai84@gmail.com if you can send any specific code you think that can help me ..

thanks a lot in advance

Re: Dynamic value update of the inputbox

nitin_bajpai — Wed, 15 Apr 2015 10:36:16 GMT

Hi KBC,

I have tried implementing the below solution sucess fully in desktop, but when i am trying to deployed it in server side it is giving no respose.

i have made all the server level and document level changes can you please help if you have faced the same issue.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Re: Dynamic value update of the inputbox

Anonymous — Wed, 15 Apr 2015 11:47:29 GMT

Hi Nitin,

Macros are not supported in other mode apart from IE plugin mode.

you need to run it in IE plugin mode

just go to Details -> Internet explorer Plugin

and try to run the macro

Thanks

BKC

Re: Dynamic value update of the inputbox

nitin_bajpai — Thu, 16 Apr 2015 23:55:01 GMT

Thanks a lot BKC.. i was able to implement it successfully ...just one more doubt i have regarding this implementation that, is it necessary to keep all the users in QV administrator group for this application to use , if yes then how do you restrict those user to access QMC as QV administrator.

My intended user group is pretty big and do not want to add every one in QV admin group just to access this application ..is there any work around ?

Thanks a lot ...

Re: Dynamic value update of the inputbox

Anonymous — Fri, 17 Apr 2015 04:21:20 GMT

if all the users want to update the field then you need to add everyone.

I did not tested it but you can try with document admin group apart from QV administrator group

lets see if it works.

Thanks

BKC