topic Re: border color in QlikView

border color

Mon, 04 Jul 2016 10:38:32 GMT

I want to give a text object a border color using macro,and remove its rounded corners

Thnx in advance

Anonymous — Mon, 04 Jul 2016 11:18:02 GMT

Hi,

1. change border color

2. remove rounded corners

both can be do by the qlikview properties .. why u need macro for this ??

Anonymous — Mon, 04 Jul 2016 11:24:19 GMT

Hi,

Macro is not needed to remove rounded corners. You may go to the Layout tab in the Text object properties and uncheck on the 'Rounded Corners' .

Thanks,

varshavig12 — Mon, 04 Jul 2016 11:26:43 GMT

The option is directly available in QlikView.

Why macro ?

Mon, 04 Jul 2016 11:27:29 GMT

I know That but i want to Do it with Macro

rubenmarin — Mon, 04 Jul 2016 12:12:47 GMT

Hi Nishit, this is the example on automation help for removing rounding cornes:

set mybox = ActiveDocument.GetSheetObject("LB01")

mbp = mybox.GetProperties

mbp.Layout.Frame.RoundedShape = true

mbp.Layout.Frame.FixCorner = true

mbp.Layout.Frame.Pixels = 10

mbp.Layout.Frame.Power = 2

mbp.Layout.Frame.EnableBottomLeftRounded = true

mbp.Layout.Frame.EnableBottomRightRounded = false

mbp.Layout.Frame.EnableTopLeftRounded = false

mbp.Layout.Frame.EnableTopRightRounded = true

mybox.SetProperties mbp

In your case I think you only need:

set mybox = ActiveDocument.GetSheetObject("LB01")

mbp = mybox.GetProperties

mbp.Layout.Frame.RoundedShape = false

mybox.SetProperties mbp