
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
We've containers in Qlik Sense? You have any extension you working on?
Or is it related to Qlik view?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oops
It is for Qlikview
I have posted in wrong forum

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think there is no way to know which object is active in container. You might have to find a workaround.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For reference check this thread
How to Pass Active Object ID to a Button to enable the conditional show of it

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I believe it is possible. He wants a text object to be activated upon selection of a chart in a container.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- « Previous Replies
-
- 1
- 2
- Next Replies »