Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator

Textbox formula linked to Container Chart Object

I have a container CT01

I have a number of charts within the container CH01 to CH10

I also need a textbox that displays various results in similar to the statistic box but containing formulas not available in the statsistcs box.

I need to be able to link the text box to the chart

CH01 - TX01

CH02 - TX02

How can I only show the relevant textbox only when the relevant chart is selected.

Regards

15 Replies
MK9885
Master II

We've containers in Qlik Sense? You have any extension you working on?

Or is it related to Qlik view?

spikenaylor1
Creator
Author

Oops

It is for Qlikview

I have posted in wrong forum

MK9885
Master II

In layout of those text objects you can use a conditional expressions to show/hide the text object.

If a certain value is selected in your CH01 then TX01 gets activated or it will hide.

Ex: if you have a value in CH01 as SAM

Try this in your text object layout tab

if(Name='SAM',1,0)

If SAM is selected in CH01 then only TX01 shows or it will hide.

Or

If you want to select it as per the selection on field, regardless of any value to select, you can use

If(Name=Name,1,0)

Correct me if I misunderstood your requirement.

spikenaylor1
Creator
Author

The way my data is setup in excel is

batch Test1 Test2 test3 etc

so I have a container CT01 with 3 charts in

CH01 showing Dimension Batch, expression is Test1

CH02 showing Dimension Batch, expression is Test2

CH03 showing Dimension Batch, expression is Test3

Initially I would like a textbox TX01 to show ='N' & count(Batch) - just an example

Initially I would like a textbox TX02 to show ='N' & count(Batch)

Initially I would like a textbox TX03 to show ='N' & count(Batch)


I need TX01 to only be visible when CHO1 is selected for viewing, TX02 & TX03 hidden or behind

I need TX02 to only be visible when CHO2 is selected for viewing

I need TX03 to only be visible when CHO3 is selected for viewing

Many thanks for helping


neelamsaroha157
Specialist II

I think there is no way to know which object is active in container. You might have to find a workaround.

neelamsaroha157
Specialist II

MK9885
Master II

I believe it is possible. He wants a text object to be activated upon selection of a chart in a container.

neelamsaroha157
Specialist II

But for that you need to get the object ID of activated chart in container...and there is no direct way to get that (my guess)

MK9885
Master II

SVG.png

That's the object ID for a List Box

You can also use Button to activate this list box

Properties>Actions>Activate Object>='LB84'

To verify if the object is activated or no

Listbox>Properties>Caption>Active Action color >Change it to red or whatever

And when you click on the button the color changes (I.E the object gets activate) But this is just to activate object, not to hide/show (for that we know to use layout conditional option)