issue with select event

[sindhu]

hi 

plz help me,i'm just stuck over

1.after the alert message i have to display that particular states information in tabular formatted

2.when hover on  any of the state that should display that states information in pie and column chart

function drawVisualization() {

      var query = new google.visualization.Query(

          'https://docs.google.com/spreadsheet/ccc?key=0ArFGfpB6duBGdFBJNVI1c3liaXd0c3l3UVNFMmZoMEE#gid=0' );

      query.setQuery('SELECT C');

            query.send(handleQueryResponse);

    }

     function handleQueryResponse(response) {

     if (response.isError()) {

       alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());

       return;

      }

    var data = response.getDataTable();

      var map = new google.visualization.GeoChart(document.getElementById('visualization'));

google.visualization.events.addListener(map, 'select', function() {

  var selection= map.getSelection();

  var value = data.getValue(selection[0].row, 0);

          alert(value);

           if(value==""){

           

         

          map.draw(newData, newOptions);

      });

      map.draw(data,{width: 700, height: 400, region: 'IN', resolution: 'provinces' });

}

  google.setOnLoadCallback(drawVisualization);

[asgallant]

For #1, see this post: https://groups.google.com/forum/#!topic/google-visualization-api/KfmfZYUonXw 

I don't think there is an easy way to accomplish #2, but I'll look into it to see if I can come up with anything.