topic Macro for changing transparency in QlikView

Macro for changing transparency

Mon, 29 Aug 2011 13:39:20 GMT

Hi everybody,

I am currently working with multiple hidden buttons laying over a pivot table. For maintainability reasons, I would like to change the transparency of all buttons with one macro. I tried to make a macro, but could not find the method in the API guide.

Can you guys help me out?

The macro I wrote so far:

sub FixObjects
for s = 0 to ActiveDocument.NoOfSheets - 1
    set vSheet= ActiveDocument.GetSheet(s)
    Objects = vSheet.GetSheetObjects
    For i = lBound(Objects) To uBound(Objects)
        set vObject = Objects(i)
        set vObjectProp = vObject.GetProperties
        vOK = 0
        'button object...
        if vOK=0 AND vObject.GetObjectType = 5 then
           vObjectProp.Frame.AllowMoveSize = false
           vOK = 1
        end if
        'chart object...
        if vOK=0 AND ((vObject.GetObjectType >=10 AND vObject.GetObjectType <=16) OR (vObject.GetObjectType >=20 AND vObject.GetObjectType <=22)) then
           vObjectProp.GraphLayout.Frame.AllowMoveSize = false
           vOK = 1
        end if
        'any other object...
'        if vOK=0 then
'           vObjectProp.Layout.Frame.AllowMoveSize = false
'           vOK = 1
'        end if
'        if vOK=0 then
'            msgbox(vObject.GetObjectType)
'        end if
        vObject.SetProperties vObjectProp
    Next
next
end sub

 sub ChangeTransparency
for s = 0 to ActiveDocument.NoOfSheets - 1
    set vSheet= ActiveDocument.GetSheet(s)
     Objects = vSheet.GetSheetObjects
     For i = lBound(Objects) To uBound(Objects)
          set vObject = Objects(i)
          set vObjectProp = vObject.GetProperties
          vOK = 0
          'button object...
          if vOK=0 AND vObject.GetObjectType = 5 then
                    
                   ' The code for setting the transparency
                   vOK = 1
          end if
         vObject.SetProperties vObjectProp
     Next
next
end sub

Macro for changing transparency

m_woolf — Mon, 29 Aug 2011 13:56:44 GMT

I haven't used this so this is just a suggestion. Try looking for Alpha or BkgAlpha in the API Guide.

Macro for changing transparency

danielrozental — Mon, 29 Aug 2011 14:20:02 GMT

A simpler way would be to use argb($(variabletransparency), R, G, B) function as background color.

Then you can use an action (even simpler than a macro) to change the transparency factor variable.

Macro for changing transparency

Mon, 29 Aug 2011 15:04:43 GMT

@mwoolf: The class 'button' does not seem to contain the member 'layout', which is required to use BkgAlpha or Alpha.

@Daniel: Is it possible to use an expression for the background of a button? I cannot find it at the moment.

Thanks for the quick responses so far!

Macro for changing transparency

m_woolf — Mon, 29 Aug 2011 15:11:12 GMT

The IButtonProperties class should work.

For Daniel's reply: The button backgroung color can be a calcualted color. That's where you would use the expression.

Macro for changing transparency

danielrozental — Mon, 29 Aug 2011 15:14:45 GMT

You can enter an expression there

Macro for changing transparency

Mon, 29 Aug 2011 20:07:56 GMT

Thank you guys, I haven't used this api guide before so I had difficulty finding it..

Re: Macro for changing transparency

danielrozental — Mon, 29 Aug 2011 20:17:22 GMT

You should really try avoiding Macro's when possible as they have several negative effects.

Look at the attached document.