topic Re: Multiple actions within a Button in QlikView

Multiple actions within a Button

Mon, 31 Aug 2015 20:30:17 GMT

Hi,

I am doing the following actions within the button:

1. Setting a variable to 1

2. Calling a Macro to export a chart in Excel

3. Setting the variable back to 0

Now, the challenge is they don't happen sequentially as I desire. Looks like I can only have one Macro inside a button because I tried one more macro to call a hidden button to do the third action and it did not work. Please suggest how I can control the order of execution of actions within the button.

Thanks,

Sudha.

Re: Multiple actions within a Button

Anonymous — Mon, 31 Aug 2015 20:34:37 GMT

why don't you enhance the macro and set the variable back to 0?

Re: Multiple actions within a Button

Mon, 31 Aug 2015 20:37:19 GMT

Hi,

Yes I thought about it. I am new to Macros. Please help me how I can integrate,

set vShowColumn=0

after the completion of this macrosub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH02")

obj.ExportBiff "C:\Temp\GL.xls"

end sub

Thanks,

Sudha.

Re: Multiple actions within a Button

Anonymous — Mon, 31 Aug 2015 20:41:48 GMT

try this

set v=ActiveDocument.Variables("yourvariable")

v.SetContent "0",true

Re: Multiple actions within a Button

Mon, 31 Aug 2015 20:45:39 GMT

Thank you so much!! It worked