The chart shows the bars correctly, For all the divisions where the Indicator's 1 and 2 are N. The % of records that have N are shown.
(Chart1 in attachment)
When i click on the Red bar "Aviation" then I get below result.
(Chart2 in attachment)
However on click I want only the first record in aviation to be shown. i.e. the dataset get filtered for N records only. When i click again the chart comes back to display all the data.
If I add indicator1 and indicator2 also as dimensions then I get a stacked sort of chart, which does not serve my purpose.
(Chart3 in attachment)
However this allows me to narrow down to only the N indicator1 record for a Division which is what exactly I am looking for. I know there are alternate states on QlikView 11. Unfortunately I am on QlikView 10 project and have no option to switch the version. Could someone help?
I am just looking to display the chart I have initially got "Chart1" be able to drill down to division and then to respective N indicators.