topic Re: Reload QVW from Access Point in QlikView

Reload QVW from Access Point

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

Hi,

Can a user be able to Reload/Refresh a Qlik View document from Access Point, whenever he wants to synchronize the data with the data source like database , as similar to Reload Menu option in QlikView Desktop Version used by developer.

Thanks,

Lakshman

Re: Reload QVW from Access Point

kdmarkee — Fri, 08 Jun 2018 15:37:49 GMT

Any traction on this? I'm looking to do the same with QV 12. Thanks.

Re: Reload QVW from Access Point

kfoudhaily — Fri, 08 Jun 2018 15:52:21 GMT

use a VBS macro:

Sub Reload

ActiveDocument.Reload

end Sub

assigned to a button in your app.

please note that there a setup on server to allow script execution on server, google it.

also note that script exection is only possible for qlik plugin clients.

please mark as solved if it's ok for you.

regards,

Re: Reload QVW from Access Point

Anonymous — Fri, 08 Jun 2018 17:06:24 GMT

At the high level, below are the steps to achieve this. But I haven't tried. I got the below idea, by going thru the Qlik Community forum.

1. In QMC, on the task specific to the dashboard, create trigger with type as “On an external Event” , and specify a password . This task should be able to reload based on QMC predefined schedules or EDX trigger by user

2. Create an application (Web Page with button / command line app / web service ), to use the QlikView Management API. In the external application , make a call to QMC task via EDX as shown below , with the parameter values related to QDS , QMC task & QV Server

a. Create variables to store address of QlikView Server, name/id of QMC task, password specified in QMC task

b.       Handle service keys used to talk to API
(Eg):
QMSClient Client;
                   Client = new QMSClient("BasicHttpBinding_IQMS", QMSURL);
                   string key = Client.GetTimeLimitedServiceKey();
                   ServiceKeyClientMessageInspector.ServiceKey = key;

c. Make a Call to the task
(Eg) :
Client.TriggerEDXTask(new Guid("00000000-0000-0000-0000-000000000000"), Taskname, Taskpassword, "", new string[0]); # Guid refers to id of reload component in QlikView

3. Security: QlikView Server to allow reload request from QMS API, Create QlikView EDX Group with special permissions, for the user or the code calling the function to run as an account,. ( or we can create a specific user account for this purpose )

Re: Reload QVW from Access Point

kdmarkee — Fri, 08 Jun 2018 18:50:33 GMT

Thanks for the info.

Re: Reload QVW from Access Point

kdmarkee — Fri, 08 Jun 2018 18:50:54 GMT

Thanks for the info.

Re: Reload QVW from Access Point

pritishnayak4 — Fri, 21 Dec 2018 05:21:58 GMT

Hi,

do you have any link or more information regarding this??

Regards,

Pritish