topic Re: Using different Macors in a QVW in QlikView

Using different Macors in a QVW

Thu, 22 Oct 2015 17:29:17 GMT

Hi,

I need to use three similar (but different) macros within my QVW. In each macro only the highlighted portion would differ. The challenge I face is, if I modify the code in one place, the same modification gets reflected across the QVW in all other macro codes. How to modify the below code without affecting a similar code elsewhere in the QVW. FYI: I am calling these macros within a Button action.

Thanks,

Sudha.

Re: Using different Macors in a QVW

Gysbert_Wassenaar — Thu, 22 Oct 2015 17:55:58 GMT

I don't understand the problem. If you have different subroutines like you say then you can modify each subroutine without affecting the others.

Re: Using different Macors in a QVW

Thu, 22 Oct 2015 18:03:18 GMT

I have the button with the macro code in QVW as shown:

I have the similar logic within button in three places within the same qlikview document.

If I change the Chart number and/or the target file location, the change gets reflected within all the buttons (macro code) in the document. Hope you get the issue.

Re: Using different Macors in a QVW

Gysbert_Wassenaar — Thu, 22 Oct 2015 18:07:15 GMT

So you're using the same subroutine for all the buttons. If you don't want that the create more subroutines and assign the different subroutines to the different buttons.

Re: Using different Macors in a QVW

petter — Thu, 22 Oct 2015 18:07:56 GMT

You need to have three different Subs ... this is the "quickest" and "dirtyest" way of doing it:

Sub ExportExcel_1

Set obj = ActiveDocument.GetSheetObject("CH33")

obj.ExportBiff "c:\temp\yyyy1.xls"

Set v=ActiveDocument.Variables("vShowColumn")

v.SetContent "0",true

End Sub

Sub ExportExcel_2

Set obj = ActiveDocument.GetSheetObject("CH34")

obj.ExportBiff "c:\temp\yyyy2.xls"

Set v=ActiveDocument.Variables("vShowColumn")

v.SetContent "0",true

End Sub

Sub ExportExcel_3

Set obj = ActiveDocument.GetSheetObject("CH35")

obj.ExportBiff "c:\temp\yyyy3.xls"

Set v=ActiveDocument.Variables("vShowColumn")

v.SetContent "0",true

End Sub

Then use different Subs for each Button....

Re: Using different Macors in a QVW

Thu, 22 Oct 2015 18:11:56 GMT

I tried this. But even changing the sub reflects everywhere. So, if I change the sub name from 'ExportExcel' to 'Hello', it again gets reflected everywhere. The moment I try to create a new macro code within a button, by default, I get the existing code and modifying that in anyway gets reflected everywhere.

Re: Using different Macors in a QVW

santiago_respane — Thu, 22 Oct 2015 18:18:07 GMT

You could create two variables in QV (ex: vParam1 and vParam2), one per each value that changes in the macro.

Then, whithin every button's actions, set those variables with the desired values and call the macro.

The macro changed for the mentioned example:

sub ExportExcel

'set the macro variables with qv variables value
set pseudoParam1 = ActiveDocument.Variables("vParam1")
set pseudoParam2 = ActiveDocument.Variables("vParam2")

set obj = ActiveDocument.GetSheetObject(pseudoParam1 )

obj.ExportBiff pseudoParam2

....

Hope this helps.

Regards,

Re: Using different Macors in a QVW

Thu, 22 Oct 2015 18:25:37 GMT

Thanks for your suggestion. Unfortunately, I am very new to macro coding. Could you please help me with my existing code...how do I introduce new variables here. I should be able to retain my existing variable vShowColumn

Re: Using different Macors in a QVW

santiago_respane — Thu, 22 Oct 2015 18:40:21 GMT

Something like this,
Let me know if it works.

Regards,

Re: Using different Macors in a QVW

Thu, 22 Oct 2015 19:12:45 GMT

It's Awesome. Thank you! I am trying to implement this but I am getting the below error.

Re: Using different Macors in a QVW

santiago_respane — Thu, 22 Oct 2015 20:52:22 GMT

Make shure your QV variable has a string (text) value, you can try converting the pseudoParam1 to string.

Maybe this line is usefull, replace the line that throws the error with the following:

'this will let you know the value of the variable

msgbox pseudoParam1

'converting the value to a string befose passing it

set obj = ActiveDocument.GetSheetObject(cstr(pseudoParam1))

Let me know if it works.

Regards,

Re: Using different Macors in a QVW

petter — Fri, 23 Oct 2015 00:18:09 GMT

Maybe I didn't make myself very clear. Obviously you are still trying with only one sub-routine.

Create three - 3 separate Sub-routines and then create separate Buttons that point to each one - each with a different name. Then you will avoid your problem.

Re: Using different Macors in a QVW

petter — Fri, 23 Oct 2015 00:30:19 GMT

Here is an attached Application that proves that it should work if it is done like I described.

Re: Using different Macors in a QVW

rwunderlich — Fri, 23 Oct 2015 10:10:04 GMT

Sounds like you are using Linked Objects for the buttons. Right Click each button, an select "UnLink".

-Rob

Re: Using different Macors in a QVW

Fri, 23 Oct 2015 13:33:19 GMT

Hi,

Could you please tell me how to unlink the buttons. When I right click the button, I don't see any option related to link/unlink. I am using Qlikview 11.2 SR6.

Thanks,

Sudha

Re: Using different Macors in a QVW

Fri, 23 Oct 2015 17:35:30 GMT

Using three different subroutines solved the issue. Thanks!!