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

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

Mon, 30 Dec 2013 08:44:04 GMT

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

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

bbi_mba_76 — Mon, 30 Dec 2013 09:27:05 GMT

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..

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

sujeetsingh — Mon, 30 Dec 2013 11:41:30 GMT

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&comments

QlikView Macros – Useful collection | Lucian Cotea

Refer to Reference Manual Of Qlikview

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

Mon, 30 Dec 2013 11:46:56 GMT

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.

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

Wed, 07 May 2014 16:32:33 GMT

thankyou

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

hic — Wed, 07 May 2014 16:37:16 GMT

Macros are Bad.

HIC