topic Re: Macro Issue in QlikView

Macro Issue

Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

This is my first reply

I do have two table 1) Straight table 2) Pivot Table

I want to change text and font and format from Pivot

How to achieve this, My client allow Macros as well, If 6/7 Lines

Re: Macro Issue

Anil_Babu_Samineni — Sat, 24 Sep 2016 14:40:46 GMT

Hello Deepa,

Let's Assume, If you have two objects like straight object is CH01 and Pivot table is CH02

Then you want to change format for CH02, Then you need to copy paste this on your VBA

Use short key for that Ctrl + M, Then copy and paste then see, If working good

SUB Font

set obj = ActiveDocument.GetSheetObject("CH02") // set obj = ActiveDocument.GetSheetObject("CH01")

set fnt = obj.GetFrameDef.Font

fnt.PointSize1000 = fnt.PointSize1000 + 1000

fnt.FontName = "Calibri"

fnt.Bold = false

fnt.Italic = false

fnt.Underline = true

obj.SetFont fnt

END SUB

Re: Macro Issue

Sat, 24 Sep 2016 14:53:40 GMT

Hello Anil Babu,

Yes, This is i am looking. Perfect. You saved me lot time. Thank you so much.

Re: Macro Issue

praveenkumar_s — Thu, 24 Nov 2016 05:36:34 GMT

Deepa,

Don't use macros bro..Its not good practice...

Thanks,

Praveen kumar S

Re: Macro Issue

Anil_Babu_Samineni — Thu, 24 Nov 2016 07:17:59 GMT

Praveen, Would it possible without macros. If so, It's good to know. Would you share your thought to achieve this so that i can implement as per ur recommend.

Thanks in advance

Re: Macro Issue

Fri, 25 Nov 2016 12:43:11 GMT

Yes, I had thought same. But, I didn't find good option here. still waiting for that. Let's have see might Gurus can help us