Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any traction on this? I'm looking to do the same with QV 12. Thanks.
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,
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 )
Thanks for the info.
Thanks for the info.
Hi,
do you have any link or more information regarding this??
Regards,
Pritish