Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rgvavihs
Valued Contributor

Macros in qlikview

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

Thanks

6 Replies
sujeetsingh
Honored Contributor III

Re: Macros in qlikview

In what terms you say that they boost the performance?

Well they have some cons too.

amit_saini
Honored Contributor III

Re: Macros in qlikview

Hi,

Check this ,

You should treat macros as last option"

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

Thanks,
AS

saumyashah90
Valued Contributor

Re: Macros in qlikview

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

Not applicable

Re: Macros in qlikview

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.

rajeshvaswani77
Valued Contributor III

Re: Macros in qlikview

Hi,

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

thanks,

Rajesh Vaswani

advait_thakur
Contributor III

Re: Macros in qlikview

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

Community Browser