topic Re: Show/Hide Text Box in QlikView

Show/Hide Text Box

Mon, 24 Sep 2012 13:27:43 GMT

Hi,

Ive been looking for the forum and cant quite find what im looking for.

Is it possible to show a text box when a chart is opened and hide the box when the chart is minimised?

I have been trying with the conditional show on the text box without any joy.

Cheers

Re: Show/Hide Text Box

MayilVahanan — Mon, 24 Sep 2012 14:02:03 GMT

Try like this in button -> Run macro -> test

use vhide in show conditional in layout properties in textbox.

sub test

set v =ActiveDocument.Variables("vhide")

if ActiveDocument.GetSheetObject("CH02").IsMinimized then

ActiveDocument.GetSheetObject("CH02").Maximize

v.SetContent "1",true

else

ActiveDocument.GetSheetObject("CH02").Minimize

v.SetContent "0",true

end if

end sub

I think it helps or give idea how to hide or show the textbox ..I tried in button to minimize and maximize the chart at the same time to show and hide the text box.

Re: Show/Hide Text Box

Mon, 24 Sep 2012 14:02:09 GMT

Try This One by using the Button we Can show/hide by creating The Varibale .

Button->P.P->Actuins->External->Setvariable

In the Vatible(ctrl+Alt+V)

we can create like

=if(Vhidedatapoints='Hide','Show')

Re: Show/Hide Text Box

Mon, 24 Sep 2012 15:29:10 GMT

Thanks for your input; I shall test both.