topic Re: Textbox formula linked to Container Chart Object in QlikView

Textbox formula linked to Container Chart Object

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Textbox formula linked to Container Chart Object

MK9885 — Thu, 10 Nov 2016 18:12:40 GMT

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

Or is it related to Qlik view?

Re: Textbox formula linked to Container Chart Object

spikenaylor1 — Thu, 10 Nov 2016 19:16:58 GMT

Oops

It is for Qlikview

I have posted in wrong forum

Re: Textbox formula linked to Container Chart Object

MK9885 — Thu, 10 Nov 2016 19:30:12 GMT

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.

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.

Re: Textbox formula linked to Container Chart Object

spikenaylor1 — Thu, 10 Nov 2016 20:35:53 GMT

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

Re: Textbox formula linked to Container Chart Object

neelamsaroha157 — Thu, 10 Nov 2016 20:51:12 GMT

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

Re: Textbox formula linked to Container Chart Object

neelamsaroha157 — Thu, 10 Nov 2016 20:52:22 GMT

For reference check this thread

How to Pass Active Object ID to a Button to enable the conditional show of it

Re: Textbox formula linked to Container Chart Object

MK9885 — Thu, 10 Nov 2016 20:55:01 GMT

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

Re: Textbox formula linked to Container Chart Object

neelamsaroha157 — Thu, 10 Nov 2016 20:59:48 GMT

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)

Re: Textbox formula linked to Container Chart Object

MK9885 — Thu, 10 Nov 2016 21:05:20 GMT

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)

Re: Textbox formula linked to Container Chart Object

neelamsaroha157 — Thu, 10 Nov 2016 21:08:55 GMT

what I am talking about here is...if you have 5 charts in your container and only one is activated at a time then how would you get the objectID of that chart???

Re: Textbox formula linked to Container Chart Object

MK9885 — Thu, 10 Nov 2016 21:16:58 GMT

In a container also we can know which object has what obj id. If one is finding it too difficult to get an object id from a container then remove that object and get it's ID.

Also please help me understand what do you mean by 'ACTIVATED'?

Re: Textbox formula linked to Container Chart Object

neelamsaroha157 — Thu, 10 Nov 2016 21:22:29 GMT

Hope this explains it better...In the screenshot i have 2 objects in a container where My 'Sales' chart is activated currently and 'Budget' is not.

Re: Textbox formula linked to Container Chart Object

MK9885 — Thu, 10 Nov 2016 21:27:11 GMT

The condition can still be applied by taking the dimension of the chart which you want to activate/hide/show etc.

there is always a way to see the Obj ID and I'd find it ridiculous if someone says I cannot get the Object ID of an Object.

We can get Obj ID in Sense and this is Qlik view.

If it is much of a hassles then before adding the object to container get the obj id and then add it. Anyway, I like to think I can get Object ID before or after adding it to container and apply any functionality to only that object in container (which will not effect other objects)

Thanks for your explanation.

Re: Textbox formula linked to Container Chart Object

neelamsaroha157 — Thu, 10 Nov 2016 21:31:50 GMT

I never said that its hard to get ID of an object.

The question here is how you can find which object is currently activated in the container and get ID of that.

And there are more people in community who could answer this better.

Re: Textbox formula linked to Container Chart Object

spikenaylor1 — Fri, 11 Nov 2016 12:10:03 GMT

So there doesn't seem to a way of doing this.

I will therefore have to remove the charts from the container and show them all across multiple sheets along with a textbox Statiticsbox containing my formulas for each chart.

Another way of doing this is to reorganize my data.

currently for example my data is from a spreadsheet organised like this

Batch	Ratio	RatioUL	RatioLL	Bioburden	BioburdenUL	BioburdenLL
AB1234	80	95	55	108	130	100
AB1235	81	95	55	107	130	100
AB1236	67	95	55	124	130	100
AB1237	66	95	55	113	130	100
AB1238	69	95	55	123	130	100
AB1239	66	95	55	123	130	100
AB1240	68	95	55	114	130	100
AB1241	50	95	55	123	130	100
AB1242	74	95	55	109	130	100
AB1243	90	95	55	116	130	100
AB1244	57	95	55	105	130	100
AB1245	89	95	55	108	130	100
AB1246	58	95	55	121	130	100
AB1247	87	95	55	120	130	100
AB1248	86	95	55	125	130	100
AB1249	69	95	55	106	130	100
AB1250	84	95	55	120	130	100
AB1251	65	95	55	113	130	100
AB1252	53	95	55	117	130	100
AB1253	56	95	55	106	130	100
AB1254	75	95	55	105	130	100
AB1255	68	95	55	123	130	100
AB1256	55	95	55	118	130	100
AB1257	60	95	55	124	130	100
AB1258	54	95	55	116	130	100

I would need it organised like this

Batch	Test	Value	UL	LL
AB1234	Ratio	82	95	55
AB1235	Ratio	67	95	55
AB1236	Ratio	53	95	55
AB1237	Ratio	52	95	55
AB1238	Ratio	73	95	55
AB1239	Ratio	50	95	55
AB1240	Ratio	76	95	55
AB1241	Ratio	78	95	55
AB1242	Ratio	53	95	55
AB1243	Ratio	73	95	55
AB1244	Ratio	70	95	55
AB1245	Ratio	66	95	55
AB1246	Ratio	77	95	55
AB1247	Ratio	68	95	55
AB1248	Ratio	80	95	55
AB1249	Ratio	81	95	55
AB1250	Ratio	64	95	55
AB1251	Ratio	59	95	55
AB1252	Ratio	84	95	55
AB1253	Ratio	67	95	55
AB1254	Ratio	52	95	55
AB1255	Ratio	77	95	55
AB1256	Ratio	69	95	55
AB1257	Ratio	77	95	55
AB1258	Ratio	56	95	55
AB1234	Bioburden	117	130	100
AB1235	Bioburden	112	130	100
AB1236	Bioburden	117	130	100
AB1237	Bioburden	111	130	100
AB1238	Bioburden	110	130	100
AB1239	Bioburden	110	130	100
AB1240	Bioburden	108	130	100
AB1241	Bioburden	121	130	100
AB1242	Bioburden	118	130	100
AB1243	Bioburden	111	130	100
AB1244	Bioburden	122	130	100
AB1245	Bioburden	110	130	100
AB1246	Bioburden	114	130	100
AB1247	Bioburden	124	130	100
AB1248	Bioburden	125	130	100
AB1249	Bioburden	112	130	100
AB1250	Bioburden	105	130	100
AB1251	Bioburden	125	130	100
AB1252	Bioburden	116	130	100
AB1253	Bioburden	119	130	100
AB1254	Bioburden	112	130	100
AB1255	Bioburden	117	130	100
AB1256	Bioburden	112	130	100
AB1257	Bioburden	120	130	100
AB1258	Bioburden	108	130	100

Obviously this is just an example

I have about 30 columns to reorganize

Is this practical or is a case of show multilpe charts alongside multiple textboxes