topic Re: Macro to turn Auto Minimize on/off in QlikView

Macro to turn Auto Minimize on/off

LuisMa — Sat, 16 Nov 2024 04:50:46 GMT

Hello!

This is my first question in this community. Sorry in advance if I make any formatting mistake.

I hope someone can help me with this: I have 4 buttons in my report, each one of them changes the way the user can view the charts.

1st button: "Maximizes" all charts, allowing the user to see only 1 chart at a time (in any given sheet).

2nd button: splits all charts and resizes them so the user can compare 2 charts. This button splits the charts vertically.

3rd button: splits all charts and resizes them so the user can compare 2 charts. This button splits the charts horizontally.

4th button: splits all charts and resizes them so the user can compare 4 charts.

So far, this works well but...

All charts have the option "Auto Minimize" turned ON. Yes, I can turn it off for every single chart but in case the user is viewing the info one chart at a time (with the first button), charts could get one in front of another.

What I want to know is:

Is there a property of the object to turn auto minimize on/off through macro?

So far I've tried things like:

set xObject = ActiveDocument.GetSheetObject("Tick_Ch_TickM")
xObject.autominimize = false

But had no success.

Thanks in advance! I don't think I need to share the file, because all I want is to turn on/off autominimize for a chart, through a macro.

Re: Macro to turn Auto Minimize on/off

rwunderlich — Fri, 04 Jan 2019 22:06:57 GMT

Example code from the API Guide:

rem ** Set auto-minimize flag for a chart **
set g = ActiveDocument.GetSheetObject("CH01")
set gp = g.GetProperties
gp.GraphLayout.Frame.AutoMinimize = true
g.SetProperties gp

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Macro to turn Auto Minimize on/off

LuisMa — Tue, 08 Jan 2019 12:18:39 GMT

Worked like a charm!

Thank you, Rob.

In case I need to set another object property with macros and don't want to bother the community with another post, where could I find a list with the property code names?

Re: Macro to turn Auto Minimize on/off

rwunderlich — Tue, 08 Jan 2019 13:09:43 GMT

The current API Guide should be downloadable here https://help.qlik.com/en-US/qlikview-developer/November2018/Content/QV_HelpSites/APIsAndSDKs.htm under "QlikView COM API reference". However, this link downloads an old V10 document. I've reported the problem in a feedback.

In the meantime, I'm attaching the V11 doc which is the latest I have.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Macro to turn Auto Minimize on/off

LuisMa — Tue, 08 Jan 2019 13:11:22 GMT

Thanks again, Rob!
Kind regards,