topic Re: How to use Run Macro in qlikview ? in QlikView

How to use Run Macro in qlikview ?

Mon, 22 Sep 2014 10:19:48 GMT

hi,

I Created Qlikview file.I created Macro In that file But the macro did not work ple tell me out how to solve that problem.

I do not know how to create macro ple help me.I attached script snipping file and object snipping filebelow this box.

Thank you

Regards:

Madhu

Re: How to use Run Macro in qlikview ?

amit_saini — Mon, 22 Sep 2014 10:23:14 GMT

Madhu,

Follow link in the attachment.

Thanks,

Re: How to use Run Macro in qlikview ?

Mon, 22 Sep 2014 10:26:16 GMT

press ctrl M

then write code as

******************************

Sub zoomfit0

.....

......

end sub

********************************

then if you want this macro on button click then button properties--> action-->

run macro

macro name =zoomfit0

then ok

same for secomd macro/

Re: How to use Run Macro in qlikview ?

Mon, 22 Sep 2014 11:18:44 GMT

I FALLOWED DIRECTIONS BUT THE SCRIPT SHOW ERROR PLE HELP ME HOW TO SOLVE THIS PROBLEM

I WRITE SCRIPT LIKE THIS .SEE AND SOLVE MY PROBLEM.

***********************************

sub zoomfit0

set mysheet = ActiveDocument.Activesheet

set sp=mysheet.GetProperties

sp.Zoomfactor=-1

mysheet.Setproperties sp

ENDSUB

*******************************

sub zoomfit1

set mysheet = ActiveDocument.Activesheet

set sp=mysheet.GetProperties

sp.Zoomfactor=1.35

mysheet.Setproperties sp

EndSub;

REGARDS:

MADHU

Re: How to use Run Macro in qlikview ?

Mon, 22 Sep 2014 14:02:31 GMT

I FALLOWED YOUR DIRECTIONS VISHWARANJANKUMAR BUT THE SCRIPT SHOW ERROR PLE HELP ME HOW TO SOLVE THIS PROBLEM THANK YOU.

I WRITE SCRIPT LIKE THIS .SEE AND SOLVE MY PROBLEM.

***********************************

sub zoomfit0

set mysheet = ActiveDocument.Activesheet

set sp=mysheet.GetProperties

sp.Zoomfactor=-1

mysheet.Setproperties sp

ENDSUB

*******************************

sub zoomfit1

set mysheet = ActiveDocument.Activesheet

set sp=mysheet.GetProperties

sp.Zoomfactor=1.35

mysheet.Setproperties sp

EndSub;

REGARDS:

MADHU

How to use Run Macro in qlikview ?