topic Re: Condition Show Text Box if Chart Active in QlikView

Condition Show Text Box if Chart Active

MalcolmCICWF — Fri, 06 Apr 2018 14:15:06 GMT

I have some text boxes to overlay on a line chart, but they are only relevant to that chart. Is there a conditional show expression to make a text box only show it a specific chart is active or maximized?

Re: Condition Show Text Box if Chart Active

chematos — Fri, 06 Apr 2018 14:18:50 GMT

If you create in some way an action to activate or maximize the chart (a button for example), then you can set a variable in this same action and use the variable as a condition to show/hide the text box and the chart as well if needed.

Hope this helps

Re: Condition Show Text Box if Chart Active

vishsaggi — Fri, 06 Apr 2018 15:07:21 GMT

Can you give an example and a snapshot. I believe you cannot capture Char minimized and maximized without using a Macro. Read here: Is this object minimized???? | Qlik Community

If you can give us little more information on what you are trying to achieve, may be we can have a solution.

Re: Condition Show Text Box if Chart Active

MalcolmCICWF — Fri, 06 Apr 2018 16:47:25 GMT

The "Collections Timeline" on the left is what lines up to the text boxes at the bottom. I only want them visible if that chart is active.

Re: Condition Show Text Box if Chart Active

chematos — Fri, 06 Apr 2018 17:05:40 GMT

Instead of using the minimized object on the left, you can use Text Objects or Buttons with the title of the chart and add actions when you click on the button. In the action you can set a value to a variable and use it to show/hide the chart and the text objects as I mentioned in my previous answer.

Regards

Re: Condition Show Text Box if Chart Active

MalcolmCICWF — Fri, 06 Apr 2018 18:16:58 GMT

Ok, I think I understand what you are saying. I have used something similar to hide/show expressions and such, but not sure I have done this for an object, much less multiple. Can you point me in the direction of the syntax or command to show/hide a chart/text box?

Re: Condition Show Text Box if Chart Active

chematos — Fri, 06 Apr 2018 19:00:18 GMT

Set a variable vShowHide = -1

Create a text object and create an action in the properties of the text object. There you will find an action called Set variable, so you can use the variable to switch the value from -1 to 1 every time you click on the object:

define the value as =$(vShowHide)*-1

Then, for each object you want to show/hide, go to the Layout menu in the properties and set the Conditional as vShowHide=1

You may need to play with more variables if you add more charts to the same tab, so just explore this option, I think it will be useful

Re: Condition Show Text Box if Chart Active

vadim_grab — Fri, 11 May 2018 08:38:21 GMT

Jose, hello

Missed understand - "define the value as =$(vShowHide)*-1"... There at the Object СH81 (Chart) i have to define this value?

My example:

and show this object (inbox)

inbox Conditional

Set variable vShowHide

Many thanks for your answer!

Re: Condition Show Text Box if Chart Active

chematos — Fri, 11 May 2018 11:34:29 GMT

Let's see.

You defined the initial state of the variable as -1

And your show condition is vShowHide=1

What I see is that you have a container, but as far as I know, you cannot add a trigger when you change from one chart to the other. So, in my example, instead of having a container, I would use buttons or text objects to show/hide the charts. In a button or a text object you can add Actions, and one of them is Set Variable, there you would use the =$(vShowHide)*-1 to change the variable value when you click on the button/text object.

Hope this helps, regards.

Jose

Re: Condition Show Text Box if Chart Active

vadim_grab — Fri, 11 May 2018 12:43:13 GMT

Thanks Jose!

With button or text don't have a problem.

My task - do it use container. May be you have more idea how i can do it?

Re: Condition Show Text Box if Chart Active

chematos — Fri, 11 May 2018 13:15:35 GMT

I can just think about a function to get if an object is active or not, but it doesn't exist as far as I know, at least in the Get* functions... Being the charts in the same position and in a container, it is just the worst combination for this kind of customization.

There is a "dirty" way. Copy the images of the container buttons and create text objects in the same position than those buttons and replicate the same behavior than the container with the text objects. The user should not notice that there are text objects there instead of the container buttons. I am not sure if that works and it is not how it should be done, but it is the best I have.

Re: Condition Show Text Box if Chart Active

vadim_grab — Fri, 11 May 2018 14:15:27 GMT

Jose, thanks!

I'll try "dirty" way

Vadim