Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could put a calculation condition on that chart.
Something like this:
=IF(GetSelectedCount(REGION)>0,0,1)
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?
i don't understand the question.
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).
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.
How can it be done for lower version of Qlikview, say version 8.20 ?