Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
May i know how to conditionally display one chart based on selection in another chart ?
If the selection is on a particular field (for example you will select Year in your first chart), you can use a trigger on select of that field. Trigger would change a value of a variable and you can use that variable in your second chart to conditionally show up.
Above is just an idea and will make things very messy because every time you select Year the second chart would show up. If that is something you want, then it would work.
HTH
Best,
Sunny
If you mean to conditionally show/hide the chart, then set a condition on the field in which you are making the selection - in the Layout tab, show condition. Something like
=GetSelectedCount(FieldName) > 0
If you mean to always show the chart but only calculate it when the condition is met, then set the condition on the General tab, Calculation Condition.
You do not make selections in a chart as such. Any selection is a selection in a field. You may do this selection using a chart, but QV does not "know" which sheet object is used to make the selection, only the field name and value(s) selected.
HTH
Jonathan
If the selection is on a particular field (for example you will select Year in your first chart), you can use a trigger on select of that field. Trigger would change a value of a variable and you can use that variable in your second chart to conditionally show up.
Above is just an idea and will make things very messy because every time you select Year the second chart would show up. If that is something you want, then it would work.
HTH
Best,
Sunny