topic Can We Write Macro Script In Chart Object Expression in QlikView

Can We Write Macro Script In Chart Object Expression

Thu, 07 Jan 2010 10:53:21 GMT

1) This state shows error when i written below statement in Chart Property->General Tab->

Window Title->Expression

if(ActiveDocument.GetSheetObject("CH01").IsMaximized,'Sales Object',

'Sales According Months')

i want to know its possible to write or can we use macro script in chart object expression.

2) Basically i want to do change chart object window name when chart object is minimize or maximize.

Please guide me

Can We Write Macro Script In Chart Object Expression

Thu, 07 Jan 2010 13:13:50 GMT

The quick answer is NO. You can't use macros anywhere outside of the "Edit module" window.
You can use a chart title instead, or text in chart. That way the window title will remain the same but obviously the chart title won't be shown when the chart is minimized.

/Fredrik

Can We Write Macro Script In Chart Object Expression

Fri, 08 Jan 2010 06:24:03 GMT

Ok fine and Thanks.