topic Re: Macro for reloading the Qlikview document in QlikView

Macro for reloading the Qlikview document

Tue, 27 May 2014 06:00:44 GMT

Hi,

I had a Qlikview file with Button. Once I clicked on the button it should relaod the document and show values based on the selection. I got this macro:

sub myreloadfunction

ActiveDocument.Reload

end sub

But its not working in Accesspoint.

Can anyone please help ASAP.

Thanks,

Sahithya

Re: Macro for reloading the Qlikview document

Tue, 27 May 2014 06:06:41 GMT

Sorry to tell you but in Accesspoint you cannot reload a document. you can only do it directly in QV.

regards,

Re: Macro for reloading the Qlikview document

Tue, 27 May 2014 06:13:20 GMT

My actual requirement is like,

This is Qlikview integration with R. I have a list box with 6 patients.

When we select the patient, it should connect to R and get the graph plotted for the selected patientand show it in my dashboard.

Based on patient selection , graph should be fetched from R and show it in Qlikview.

Re: Macro for reloading the Qlikview document

Tue, 27 May 2014 06:17:51 GMT

Macro's are not working in access point.

Re: Macro for reloading the Qlikview document

PradeepReddy — Tue, 27 May 2014 07:04:29 GMT

some of the Macros won't work in Ajax Plug-in.

Try the below approach, might be helpfull...

Document Properties --> Triggers --> Field Event Trigger --> Select Field(Patient)--> add action --> External -- > Reload.

Thanks,

Pradeep

Re: Macro for reloading the Qlikview document

jerrysvensson — Tue, 27 May 2014 07:08:27 GMT

Can't understand why people keep saying that no macros work in Ajax.

If you read the Reference manual you will se that not all macros and events work in Ajax, but macros does work in Ajax.

Please don't spread incorrect information!

Re: Macro for reloading the Qlikview document

Tue, 27 May 2014 07:16:32 GMT

But fact is that you cannot reload a document in access point regardless if it is with IE plugin or AJAX

regards,

Re: Macro for reloading the Qlikview document

Mon, 07 Jul 2014 11:34:21 GMT

You can run a batch file from a macro, macro which can be assigned to a button in QlikView.

The batch file contains a simple reload command (for example):

"C:\Program Files\QlikView\qv.exe" /r C:\QlikView\Documents\YourQVW.qvw

I did this on Chrome and it worked good.