I have a requirement wherein there is a straight table chart with dimension called metric name when i click on the data present in that column (say i click on metric_a)it shud take me to another sheet which has a text box with sum(value) for metric_a.similarly when i click on metric_b in the straight table of the 1st sheet it shud take take to another sheet which has a text box with sum(value) for metric_b.
I have attached the sample application.Please let me know how this could be acheived
If everytime after selecting a value in field "Metric", you want to land on the same sheet (The one which contains Sum) then you can use Actions/Triggers.
You can got to Settings--Document Propeerties--Triggers--Field Event Triggers (As Bill has mentioned in his answer)
Here you can add an action Onselect & Onchange of the field.
Action Type : Layout
Action : Activate Sheet
You can tweak this logic per your needs.
Hope this helps!
In the attachment put up you have hard coded the scenario as
If(Fields='Amount1', 'SH02',If(Fields='Amount2', 'SH03'))
So incase a new field called amount3 is added at the backend you will have to change the code to add it again.But I want this to be dynamic like when a field value is selected on the chart it should take to another sheet providing me with the detailed analysis.
But in the approach used here,if there 10 such fields we will have to put in a nested if and this goes on as the number increases.is there any other better turn around option for this?
If there are backend changes, like say adding a new database column to be used as metric, then that by definition will require amending your qvw, especially the script.
Best Regards, Bill
Thanks for the suggestion.But i have another constraint,as we have set these properties at document level this activation holds good for all the sheets.But i do have other sheets referencing to the same fields and when i click on them,i still navigate to the respective sheets, which should not happen so can we make this property to be valid only on particular sheet? and not apply to all of them