Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
Showing results for 
Search instead for 
Did you mean: 

Is there any way change chart's height without macro??

I know it works fine with macro, but there's some limitation our organization not allow us to use macro.

the macro's functionality is as below:

   set sh = ActiveDocument'.ActiveSheet

    set v = ActiveDocument.GetVariable("vSubgroupCnt")

    getVariable = v.GetContent.string

    set obj = sh.GetSheetObject("CH13")

     set fr = obj.GetFrameDef

     set pos = fr.Rect

    pos.Height = (32*CDbl(getVariable)+50)*2.5


        obj.SetFrame fr,true,dummy

    ActiveDocument.Variables("vheight").SetContent pos.Height, True

the function is work well within qvw, but we just be noticed it is not allowed, how can I resize the object dynamically without macro?? thanks!!!

2 Replies

By default its allowed to move and change size of the Objects. There is also a settings in layout tab-->Options where you can tick or untick this.

Creator III
Creator III

Maybe you can use two objects, and a action with variables to hide/show the small or big graph.

Why you need to resize the graph? Maybe there is another solution.