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.
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.
This is without any changes - two charts, two details tables with different fields showing.
and this is when you make a selection in either of the charts.
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.