I believe out of the box new sheet is not possible in qlik sense. you may consider exploring an extension for this.
selecting one sector in a pie-chart and getting additional details is a typical standard feature. have a pie chart, a details table chart and as long as you have dimensions that are common / impacted or related - it will change based on the selections in the pie chart or vice versa.
without any selection
after making some random selections
is this something you are looking to get?
Thanks for your reply! your answer gives a partial solution to my needs. I have many charts in my dashboard app, and each chart corresponding to different selection criteria. So if i click on a selection in chart 1, i need the table to be of a given format, while selecting in chart 2 should give me a table in with other fields. Is there any way to do this!!
I think what you are looking for is a classic case of set analysis. If I understand it right, here is what you are looking for.
I am using the Executive Dashboard that comes with your QS version. In most cases, you want to see an impact of your selection in one chart across other but you can stop it by using set analysis and forcing the details table to change only based on selections of certain dimensions.
If you have an example app that you can share, I can provide more specifics of how to make it work. Alternatively, mto has a great demo/discussion at this link - https://community.qlik.com/docs/DOC-8174
let me know how it goes,