topic Macros in qlikview in QlikView

Macros in qlikview

Anonymous — Thu, 18 Dec 2014 06:08:31 GMT

why macros doesn't boost up the performance ? Isn't because of as they are single threaded ?

Thanks

Re: Macros in qlikview

sujeetsingh — Thu, 18 Dec 2014 06:10:11 GMT

In what terms you say that they boost the performance?

Well they have some cons too.

Re: Macros in qlikview

amit_saini — Thu, 18 Dec 2014 06:12:38 GMT

Hi,

Check this ,

You should treat macros as last option"

http://community.qlik.com/message/489705#489705

Thanks,
AS

Re: Macros in qlikview

saumyashah90 — Thu, 18 Dec 2014 06:24:16 GMT

1)s they are single threaded.

2) works sequentially and if you are pulling or writing any data in excel it does it cell wise hence it makes the working very slow

3)And macros doesnt work on the server when it is Ajax so better not to use macros

Re: Macros in qlikview

Thu, 18 Dec 2014 06:27:49 GMT

Hi rgv, This question has been answered in this community, and I found this link : http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/28/macros-are-bad very useful, hope this helps in answering and enriching your knowledge in macros, enjoy.

Re: Macros in qlikview

rajeshvaswani77 — Thu, 18 Dec 2014 06:44:21 GMT

Hi,

Definitely they will consume some processing time. Macros have nothing to do with increasing performance.

thanks,

Rajesh Vaswani

Re: Macros in qlikview

advait_thakur — Thu, 18 Dec 2014 06:47:30 GMT

Hello Rgv,

Macros cannot boost performance in QlikView instead it might effect overall performance of your app. It also depends on complexity of your macro and how QlikView is understanding it, in may cases a simple macro will definitely give you quick response but complex cannot. Also the browser matters a lot while applying macro, sometimes it runs and sometimes it fails.

I will highly recommend you to avoid macros in QV until and unless its really needed.

Regards

Advait