topic Creating Macros in QlikView

Creating Macros

janardhan — Mon, 21 May 2012 07:08:50 GMT

How to create Macro? Can any one pls explain and also give the example

Creating Macros

Miguel_Angel_Baeyens — Mon, 21 May 2012 07:21:50 GMT

Hi,

Go to the Module Editor (Ctrl + M) and select the language you are going to use. Most of the examples (if not all of them) in these forums are written in VBScript, just search the forums for macro and whatever you want to achieve.

Hope that helps.

Miguel

Creating Macros

janardhan — Mon, 21 May 2012 07:38:03 GMT

can u pls explain in detail...

Thanks

Creating Macros

Miguel_Angel_Baeyens — Mon, 21 May 2012 08:05:12 GMT

Hi,

Check this thread that creates a macro to export a chart to Excel. Without further information on what do you want to achieve, I cannot suggest anything more detailed.

Regards.

Miguel

Creating Macros

janardhan — Mon, 21 May 2012 08:51:57 GMT

Thanks for ur help

Re: Creating Macros

IAMDV — Mon, 21 May 2012 16:23:13 GMT

Hi Janardhan,

Let me add my two cents... here are few things I have done to learn VB Scripting.

VB Scripting is very similar to VB/ VBA. So I would recommend you start understanding object orientied programming. Probably look out for online tutorials. I come from VBA background, so it was easy for me to pickup VB Scripting and interacting with QV API.

Try to understand the difference between Methods, Properties, Objects and Events. Once you understand this difference you need to learn debugging. Unfortunately, QV doesn't support VB Script debugging. However, you can use traditional MessageBox style debugging.

Try to learn programming constructs like Conditional Statements, Loops and Functions. These are used very often in procedural programming.

Most important : Subscribe to top community users. For example, I have subscribed to John Witherspoon, swuehl, Miguel Angel Baeyens and Erich Shiino. There are some users who specialize in VB Scripting/Macro based solutions. Look out for them and subscribe to their posts. I learn a lot this way.

Once you understand the basics of VB Scripting try providing solutions on community. This way you are exposed to different situations. I try to do the same with my weak areas in QlikView.

I hope this helps!

Happy learning.

Cheers - DV

Re: Creating Macros

Wed, 17 Oct 2012 13:51:37 GMT

Hi Deepak, can you suggest any document for understanding differance between objects, events ,funtions .

and scenarios of their usage as well.

Thanks.

Re: Creating Macros

IAMDV — Fri, 19 Oct 2012 08:01:13 GMT

Hi Vidya,

Please check the QV API document. It is user friendly once you understand what needs to be done. I'll check if there is any other material available.

Cheers,

www.QlikShare.com

Re: Creating Macros

Fri, 19 Oct 2012 09:38:51 GMT

I guess the intended recipient is some other Vidya. Please send the mail

to the intended recipient.

Regards,

Vidya

Team Lead

Tata Consultancy Services

No 42, Think campus

Electronic City phase II

Bangalore - 560100,Karnataka

India

Cell:- 9900171854

Mailto: v.vidya@tcs.com

Website: http://www.tcs.com

Re: Creating Macros

IAMDV — Fri, 19 Oct 2012 10:00:41 GMT

Sorry I'm lost here... what do you mean by some other Vidya?