5 Replies Latest reply: Sep 19, 2011 4:20 AM by Deepak Vadithala

populate chart from bar chart

Tom Nohelty Sep 17, 2011 7:35 PM

Is there a way that I can create a chart table that has the detail for everything that makes up a bar in a bar chart?

I am trying to get the detail for all revenue if I click on the revenue bar for customer A(see attached image) into a detail table that somone can view and/or export. Essentially, I want to be able to drill down into detail for the chart. It can populate another chart on the same or different sheet. Thanks for any help.

chart.png 5.0 K

Re: populate chart from bar chart

Deepak Vadithala Sep 17, 2011 7:57 PM (in response to Tom Nohelty)

Hi,

I think you can use the GetFieldSelection() Function for Revenue Field to capture the selections. Once user clicks on the main chart (attached above) on the Revenue Bars, you can hide this chart by conditional Show/Hide in the Chart Properties. Then you can show the second chart which shows detailed information. I would recommend locking the position of the charts after overlying them, you can change the properties in layout menu and uncheck the allow move/size.

I hope this helps!

Cheers - DV
Like Show 0 Likes (0)

Actions
- populate chart from bar chart
  
  Tom Nohelty Sep 17, 2011 9:56 PM (in response to Deepak Vadithala)
  
  Could you tell me where this function should be inserted? I dont see a spot in any of the property pages that you can put functions other than the definition of the expressions themselves. Example code may help. Thanks
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: populate chart from bar chart
    
    Kiran Rokkam Sep 18, 2011 9:56 AM (in response to Tom Nohelty)
    
    I attached an example with dynamic visiblity based on cutomer selection. You can see the property in the layout tab of the chart properties.
    
    Regards,
    Kiran.
    
    test.qvw 136.0 K
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: populate chart from bar chart
      
      Tom Nohelty Sep 18, 2011 5:34 PM (in response to Kiran Rokkam )
      
      I am sure this would answer my question, but I am unable to read the file. I am using the personal edition that is free and it will not allow me to read a file unless it is created by me. Is there a way to get around this to look at examples like this? Thanks for your help.
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: populate chart from bar chart
        
        Deepak Vadithala Sep 19, 2011 4:20 AM (in response to Tom Nohelty)
        
        Yes, Kiran demonstrated the solution I have explained earlier. Thanks Kiran!
        
        You will generally have 3/4 attempts to open others files in personal edition. If you wanted to see the functionality then you can use one of the attempt. I hope this helps!
        
        Cheers - DV
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post