topic Re: Macro with a button to reload the data in QlikView

Macro with a button to reload the data

raghavsurya — Fri, 26 Aug 2011 12:06:16 GMT

Hi,

We have a requirement wherein the user wants to update few templates provided to different departments within the organization and click on a button to get the data loaded onto qlikview application.

Can anybody share with me any macro to enable Reload into Qlikview.

Regards,

Raghav

Macro with a button to reload the data

kaushiknsolanki — Fri, 26 Aug 2011 12:13:48 GMT

Hi,

With normal API's its not possible as per my knowledge, but i think it might be achieved with the help of ServerSide API.

Dont know much about ServerSide API. Will rearch on this and will get back to you.

Regards,

Kaushik Solanki

Re: Macro with a button to reload the data

Miguel_Angel_Baeyens — Fri, 26 Aug 2011 12:15:18 GMT

Raghav,

The following will only work when openin the document locally using Desktop. This will never work in a client - server environment, you should create an EDX triggered task if you have the Publisher license.

Sub ReloadDoc

ActiveDocument.Reload

End Sub

Now you can call this sub in an action, for example.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Macro with a button to reload the data

raghavsurya — Fri, 26 Aug 2011 12:17:48 GMT

Thanks a lot Miguel.

Macro with a button to reload the data

raghavsurya — Fri, 26 Aug 2011 12:19:26 GMT

thx Kaushik.... let me know if you are able to crack it . Regards, Raghav

Macro with a button to reload the data

Wed, 09 Nov 2011 13:56:56 GMT

Hi Miguel,

How to create a EDX trigger action for reload the application in server machine.

Please list the steps to follow.

Thanks

Macro with a button to reload the data

Anonymous — Thu, 01 Dec 2011 09:13:01 GMT

Did you find any solution to this?

I have an edx that seems to run as it should.

But I also try to reload with a variable but I have not managed to get it to work.

Dan

Macro with a button to reload the data

spinchuk — Thu, 08 Dec 2011 19:06:03 GMT

Miguel, how would you modify this script to trigger reload of not active document, but any document on server drive?

For example i need to trigger reload of MyDoc.QVW located on C drive.

Sub ReloadDoc ActiveDocument.Reload End Sub

Thank you!

Re: Macro with a button to reload the data

Miguel_Angel_Baeyens — Thu, 08 Dec 2011 20:16:08 GMT

Hi Sergey,

That will only work opening the document with the Desktop client locally, not with the Plugin or Ajax client and never in a server environment, if that's what you mean. Check this document on how to create an EDX triggered task in QlikView.

Hope that helps.

Miguel

Re: Macro with a button to reload the data

spinchuk — Thu, 08 Dec 2011 20:33:17 GMT

Problem is - I don't have publisher...

What i'm trying to do is to trigger a reload of QVW if it falied to reload. Basically try to reload it again. This all happens on server - no user involved.

Would you happen to have s suggestion?

Thank you.

Re: Macro with a button to reload the data

flipside — Thu, 08 Dec 2011 22:07:47 GMT

With a bit of clever configuration, it should be possible to trigger reloads without the need for Publisher/EDX etc..

What I have done is schedule a simple qvw (let's call it a 'control' qvw) to run every minute. All it does is look for the existence of a txt file on the server. The txt file is generated using a macro with ServerSideExport of a simple object in the document I want to be triggered and in my document this is called from a button.

When the scheduled control qvw doesn't find the file (use an 'if FileSize(file)>0' statement in the load script), it just completes normally. If it DOES find the file, make the load script do something that will fail, such as 'Load NonField resident NonTable'. The document you DO want to reload needs to be set up to run only when the control document fails. You will also need to delete (EXECUTE cmd.exe \c del) the file to prevent the control app from continuously failing - just do this in the control app just before you set the fail script.

For the issue where you want to reload a failed document reload, you might be better to store a counter in the text file so that you can control a maximum number of times a reload is attempted, and read the value back on each attempt.

flipside

Re: Macro with a button to reload the data

Miguel_Angel_Baeyens — Thu, 08 Dec 2011 22:33:59 GMT

Yes, this is another option. Even a continuous QVW file checking for a value in field stored in a QVD file with a timestamp can give you more control on what is happening.

Miguel

Macro with a button to reload the data

Wed, 21 Dec 2011 01:52:27 GMT

Hi Miguel,

Does this work if the user access the qvw via Access point?

i tried, and it didn't work.

Could you advise?

Thanks,

nick

Macro with a button to reload the data

raghavsurya — Wed, 21 Dec 2011 05:09:55 GMT

Hi Nick,

This does not work through accesspoint.

Regards,

Raghav

Re: Macro with a button to reload the data

Tue, 03 May 2016 06:44:45 GMT

Hi Raghavendra,

Please find the following code that will helps to you.

Sub ReloadDoc()

ActiveDocument.Reload

End Sub

Regards,

Sreenadha Reddy P