Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
Master
Master

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.

Highlighted
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.