topic Problem with button action in QlikView

Problem with button action

Thu, 28 Jul 2011 20:54:30 GMT

Hi All,

If i have 2 charts which i have auto-minimized, and i have a 1 line text below each chart specifying what the chart depicts, so when the chart is displayed, i want the text to be displayed too.

How can i expand/collapse the text with the chart?

Thanks!

Problem with button action

Thu, 28 Jul 2011 21:21:39 GMT

I dont want to add buttons for this. Only when someone clicks on the chart, its text should automatically also be displayed.

So i guess we wil have to write something in the layout -> conditional part of the chart. Like specify the object ID. But what is the syntax for this?

Problem with button action

erichshiino — Fri, 29 Jul 2011 02:57:29 GMT

Hi,

Can you include a text inside the chart so they move together?:

You can include on in Chart properties-> Presentation -> Then "Text in Chart" -> Add...

After you create you text, you can move it clicking on the chart, then holding Ctrl+Shift and you will be able to move the label.

Hope this helps,

Erich

Problem with button action

Fri, 29 Jul 2011 13:39:22 GMT

Hey Eric,

The text is in a seperate text object. I cannot put it in the chart. But thanks for your suggestion!

Problem with button action

Fri, 29 Jul 2011 14:53:39 GMT

hi,

You can minimize the chart and text box both in same time.

right click on sheet -> properties--> trigers

select the chart object on edit action

click on add --> layout -->minimize object

enter the chart object ID at object ID input box

click on add --> layout-->minimize object

now enter the text box object ID here

Note: You sholud change the text box object properties too.

right click on text box --> properties -->caption

check the allow minimize check box.

this will help you.

Sumit

Problem with button action

Fri, 29 Jul 2011 15:39:12 GMT

Hi Sumit,

Thanks for your response!

So i know how to auto minimize the chart. But i only want the text to be displayed when the chart is displayed. So i guess ill have to just link the text object with the chart n vice versa.

How can i do this? i dont want to auto minimize the text object.

Problem with button action

tanelry — Fri, 29 Jul 2011 22:32:13 GMT

Try this...

Set up a variable vHelpText.

Then add your text object with formula =vHelpText

Then open sheet properties > Triggers

In the Sheet Object Event Triggers add triggers to each chart:

OnActivate - add Set Variable command to write relevant text into variable vHelpText

OnDeactivate - add Set Variable command to write empty string into variable vHelpText

Now the text box shows relevant text as soon as chart is activated.

You can auto-hide the text box with show condition: len(vHelpText)>0

Alternatively (more simple) use Caption > Help Text in the chart properties and teach your users to click the big "?" in the chart's upper right corner for advice.

Problem with button action

Mon, 01 Aug 2011 14:31:48 GMT

The help text is a perfect solution!!

Thanks soo much!