Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we drill through from one sheet to another
I have knocked up a sample qvw with a suitable Field Event Trigger.
Click on one of the bars and it should go to the Detail tab.
Note sure what you have in mind, but not in the sense of drilling down in a dimension.
You can create buttons or triggers to navigate to other sheets and show or hide objects in that way; maybe that's a direction you are looking for?
If this does not get you a step in the right direction, please explain exactly what you are trying to achieve or, more interesting, what the Use Case / scenario is you are trying to answer / solve.
If I have a chart on one sheet and I click on bar I would like to see the detail report on another sheet.
Thanks for reply
I would guess that you want to show your "detail report" when you have one value for your dimension selected. This can be detected with the GetSelectedCount() function.
Instead of going to a different sheet I would hide / show your "detail report" and inversely show / hide your Bar Chart, by setting, on the Layout tab Show | Conditional a suitable expression. I have done things like this on occasion.
If you really want to go to a different Sheet, then you'd need to set up a Field Event Trigger.
I have knocked up a sample qvw with a suitable Field Event Trigger.
Click on one of the bars and it should go to the Detail tab.
Bundle of Thanks Bill let me search and try, if anything I will get back to you.
Thanks
Hi Bill thanks a lot
Would u ples elaborate little bit more how did you do it.
Thanks
I got it its working.
Thanks a lot