Hi All,
I am using QlikView 10. Below is the data that I am reading from the spreadsheet.
Division | Policy Number | Indicator1 | Indicator1 |
Aviation | A3 | Y | N |
Aviation | A4 | Y | Y |
Energy | A5 | N | N |
Energy | A6 | N | N |
Marine | A1 | Y | N |
Marine | A2 | N | N |
Created a bar chart. The chart has Division as the dimension, two expressions
expression1 : =Count({$<Indicator1={'N'}>} [Policy Number])/Count([Policy Number])
expression2 : =Count({$<Indicator2={'N'}>} [Policy Number])/Count([Policy Number])
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.
thanks,
Rajesh Vaswani
