topic Attach/Detach an object for selecting List Box in QlikView

Attach/Detach an object for selecting List Box

Tue, 27 Oct 2009 16:26:37 GMT

Hi,

It is possible to attach or detach a graph/Char only for some List Box? I means that, i have three list box which list Year, Services and régions. I want that, when i select a year or a service, the char/graph change for the selected values and do not change when i select a region.

Thanks for your reply

Attach/Detach an object for selecting List Box

mongolu — Tue, 27 Oct 2009 16:47:50 GMT

You could put a calculation condition on that chart.
Something like this:

=IF(GetSelectedCount(REGION)>0,0,1)

Attach/Detach an object for selecting List Box

Tue, 27 Oct 2009 17:04:54 GMT

Thanks for your reply,

When i do that, if i select a region, i got a message 'Calculation condition unfulfilled'. It is possible to put default value of list value for the graph or char?

Attach/Detach an object for selecting List Box

mongolu — Tue, 27 Oct 2009 18:11:27 GMT

i don't understand the question.

Attach/Detach an object for selecting List Box

mongolu — Tue, 27 Oct 2009 19:35:09 GMT

Attach/Detach

You could achieve this by macro.

Something like this:

SUB TEST
v_AgentCnt = ActiveDocument.Evaluate("=GetSelectedCount(REGION)")
If v_AgentCnt>0 Then
ActiveDocument.GetSheetObject("CH01").Detach
Else
ActiveDocument.GetSheetObject("CH01").Attach
End If
END SUB

And put it on the field you want (Document/Properties/Triggers/Field Event Triggers) on OnChange event.
(if you're using qv lower than ver 9, Document/Properties/Macros/Field Event Triggers).

Attach/Detach an object for selecting List Box

ssamuels — Tue, 27 Oct 2009 20:32:54 GMT

Hi,

You only want the expression values in the chart to be recalulated when you select a year or a service?

If that is what you want, you should change the expression for the calculated values by using Set Analysis.

Example:
The expression "sum($<Region = {*}> }Sales)" will calculate the sum of Sales for all the regions that are in stored in the datacloud. When you select one region the calculated value of the expression will not change.

Attach/Detach an object for selecting List Box

Tue, 01 Dec 2009 03:39:20 GMT

How can it be done for lower version of Qlikview, say version 8.20 ?