topic ShowMode in QlikView

ShowMode

Wed, 14 Jul 2010 09:14:59 GMT

i've got 2 charts on a sheet and a text box. and i want the text box to display different text depending on which chart is maximised(auto minimize is on)
i would also like a 3rd item of text to show when both are minimized but only if possible.

Whats the best way of doing this? if this is at all possible.

i orignally tried to use 2 separate textboxes and assumed i'd be able to do something like if(CH04.Showmode())='Minimised' in the conditional box of the chart. but cant find anything that would allow me to pick that property up from the sheet object.

could i use a macro?

ShowMode

Wed, 14 Jul 2010 09:32:01 GMT

can you attach a sample?

i dnt rally understand wat ur saying

ShowMode

Wed, 14 Jul 2010 09:49:28 GMT

ok see attatchment.

ShowMode

Thu, 15 Jul 2010 09:51:36 GMT

anyone got any ideas?

ShowMode

Thu, 15 Jul 2010 09:54:18 GMT

im befrazzled. i cnt figure it out man...

ShowMode

Thu, 15 Jul 2010 12:58:24 GMT

You can do it with a macro.

See attach document

Anders

ShowMode

Fri, 16 Jul 2010 13:02:31 GMT

thanks, its well over halfway to what i'm after, i'd tried setting the macro to run OnActivateSheet as well as OnActivate object and OnDeactivate.

problem is e.g. when you click on Chart B to maximise it you activate that object which runs the macro, and when the macro is run the object is still minimised. but then when you deactivate the object i.e. click on the sheet background the macro runs.

a delay/sleep would work but i cant get that to work with wscript.sleep(500) or sleep 500 or infact anything i've tried.

you still get the thanks and the prized points for the answer,

thanks