topic Re: Change SheetObject Alternate State via Macro in QlikView

Change SheetObject Alternate State via Macro

Wed, 14 Aug 2013 07:25:40 GMT

Hi.

I want to able to change Sheet Object(a chart) Alternate state on the fly by pressing a button.

Is there a macros function to do that?

My backup plan is to make 2 charts with different states and use conditional show. But the macros would be better.

tresB — Wed, 14 Aug 2013 07:47:58 GMT

Having a trigger, I would always try to avoid a macro. See the attachment

Hope this helps.

Wed, 14 Aug 2013 08:12:55 GMT

I think you didn't understand. I need to change state of a whole chart.

tresB — Wed, 14 Aug 2013 08:19:05 GMT

In that case use 'Set State Name' under Layout action type (trigger)

Wed, 14 Aug 2013 08:33:23 GMT

That worked greatly!

Ty!