topic Re: Partial load from VBS script in QlikView

Partial load from VBS script

Wed, 03 Aug 2016 11:46:50 GMT

Hello,

I want to develop a relationship that will allow users to add comments in three fields, the information in these fields will be stored in a table.

I used a macro to insert and another to update if users change their comments during the execution of this macro, Qlik recharge all data coming from different sources, while I wish the macro search one table

Are there a possibility to solve this problem.

Thank you

Best Regards

Re: Partial load from VBS script

adamdavi3s — Wed, 03 Aug 2016 14:08:50 GMT

I am pretty sure you can call partial reload in the vbs script?

Then just prefix your table with ADD LOAD

I've done similar where users need to load a local file, but maintain the data produced centrally.

They click on a button to load the action of which

1- sets v_partialreload =1

2- calls the macro to partialreload the document

Then in the load script we have the logic

if v_partialreload = 1 then

ADD LOAD * from xyz

exit script

end if

Load * from xyz;

Re: Partial load from VBS script

Wed, 03 Aug 2016 14:56:53 GMT

Thank you for your reply

I would like Script BVS launches partial load

I used ActiveDocument.Reload to reload the data,

On the other hand I wish that the execution window is not visible in the report

Tkank you

Re: Partial load from VBS script

adamdavi3s — Tue, 09 Aug 2016 11:30:32 GMT

So use the ActiveDocument.PartialReload instead?

And to hide the window you can use the function ReloadEx ( ErrorMode , ProgressMode ) where ErrorMode=0 and ProgressMode=1.