Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Reload QVW from Access Point

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

6 Replies
kdmarkee
Specialist
Specialist

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

kfoudhaily
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant
Anonymous
Not applicable
Author


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 )

kdmarkee
Specialist
Specialist

Thanks for the info.

kdmarkee
Specialist
Specialist

Thanks for the info.

pritishnayak4
Contributor
Contributor

Hi,

 

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

 

Regards,

Pritish