topic Re: Re: Start with Macro writing in QlikView Scripting in QlikView

Start with Macro writing in QlikView Scripting

agni_gold — Tue, 12 Nov 2013 10:52:05 GMT

hi ,

Please tell me how to start writing Macros in qlikview scripting.

and where to write these and how to call these in script.

Thanks

Re: Start with Macro writing in QlikView Scripting

kaushiknsolanki — Tue, 12 Nov 2013 10:58:19 GMT

Hi,

Here is the link to download the API Guide.

http://community.qlik.com/docs/DOC-2640

Regards,

Kaushik Solanki

Re: Start with Macro writing in QlikView Scripting

kaushalview — Tue, 12 Nov 2013 14:08:48 GMT

Hi,

U can write Macro in Tool--->>Edit Module or use Ctrl + M.

Regards

Kaushal Mehta

Re: Start with Macro writing in QlikView Scripting

agni_gold — Wed, 13 Nov 2013 17:02:17 GMT

After this what to do please send me some simple example to understand.

Thanks.

Re: Start with Macro writing in QlikView Scripting

rustyfishbones — Wed, 13 Nov 2013 17:10:09 GMT

Press CTRL +M to go into the Module

Add below

Sub HideTabRow

Set DocProp = ActiveDocument.GetProperties

DocProp.ShowTabRow=false

ActiveDocument.SetProperties DocProp

End Sub

Sub ShowTabRow

Set DocProp = ActiveDocument.GetProperties

DocProp.ShowTabRow=True

ActiveDocument.SetProperties DocProp

End Sub

You can then call these macro's by adding actions to buttons or text objects

The above allow you to show or hide the tab row

Hope that helps

Re: Re: Start with Macro writing in QlikView Scripting

MayilVahanan — Wed, 13 Nov 2013 17:11:33 GMT

PFA

Example to export tablebox using macro

Re: Start with Macro writing in QlikView Scripting

Bill_Britt — Wed, 13 Nov 2013 18:01:32 GMT

Need to make sure that the macros you are building will work with the Client that the users will be using. Most work great with the plugin but not with AJAX.

Bill