Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to see if there is a way to make a bar chart appear when drilling down on data in a line chart. Can Actions be used on Chart Objects?
Thanks!
Jennifer
Drill down can mean a lot of things. You could use a conditional display based on getcurrentfield() if you're using a drill down group. If you mean you're selecting values, you could use a conditional display based on whether a field has selected values using getselectedcount(). Probably other solutions for other meanings of drill down.
Thanks for the fast reply John.
I am still new to QV so I am not sure where to find information on Conditional Displays. Can you elaborate?
Regarding drill down, I mean double clicking on a line or selecting a range of points. I have a fast type change enabled to show the 2 different chart displays for the selected data but would like to enable an action to perform the change automatically when making the selection. Do you know of a way to do this?
By conditional display, I mean right click on the chart, Properties -> Layout tab -> Show -> Conditional. You can enter a boolean expression there. When true, the chart will display. When false, the chart will be hidden.
I think you could use that to do what you want. You'd need to create two charts, one for each type. So let's say that when you double click on a line, you're selecting a customer or customers. Your bar chart would have a condition of getselectedcount(Customer)>0. Your line chart would have a condition of getselectedcount(Customer)=0. Now, yours probably isn't Customer, but substitute whatever field they're clicking on. If any of several fields should trigger display of the bar chart, you could just add up the selected counts.