Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

why you should use a macro and VB-Script in Qlikview?

why you should use a macro and VB-Script in Qlikview?

5 Replies
bbi_mba_76
Valued Contributor

Re: why you should use a macro and VB-Script in Qlikview?

Hi,

in precedent version of qlikview, there are not so actions as in qlik 9-10-11. So macro were useful also to set selections, whereas now there is a standard action to do this.

There are non standard actions that you could do only with macro, ie to loop on the values of a field and then print a pdf, to repeat some actions(ie set the allow move size to all objects in all the sheets),...

But macro not always acts as aspected, ie with a client(ajax,plugin) they works with another no. And if you use the distribution service to reload the macro based on objects will not work.

Hope this help, it is not much..

sujeetsingh
Honored Contributor III

Re: why you should use a macro and VB-Script in Qlikview?

Macro are some time needed for the some extra actions which are  sometime not in-built in Qlikview.

Even some time these macros are written to just enhance some exsisting actions ,like email sending  etc.

here some links for Macros in Qlikview

http://www.satsumasolutions.com.au/Blog/Satblog.nsf/dx/01042008082531AMDSET5J.htm?opendocument&comme...

QlikView Macros – Useful collection | Lucian Cotea

Refer to Reference Manual Of  Qlikview

Not applicable

Re: why you should use a macro and VB-Script in Qlikview?

It is also worth noting that QlikView does not provide support for macros, i.e. paid customers are not likely to get help from QlikView Support if their macros do not work. For this reason and the ones outlined by Michele above I try and avoid them.

Not applicable

Re: why you should use a macro and VB-Script in Qlikview?

thankyou

Employee
Employee

Re: why you should use a macro and VB-Script in Qlikview?

Community Browser