Hi All,
I'm having a bar chart in which dimension is drill-down of Country->State->City. And expression is sum of revenue.
The problems I'm facing in this chart are
1. whenever Country field is having only one value, chart will be drilled to State directly without showing the country information to which currently displayed states belong.
2. Whenever a State is selected using State list box, drill-down will happen till City and I wont get to know about the Country and State to which currently displayed States belong.
I think this is the way qlikview behaves. Is there any way to avoid it? Or is it possible to change the chart tittle dynamically to indicate the drill down by showing the level up-to which drill-down has gone?(For Ex : in the first scenario above I want the tittle to be "Revenue by States" and in 2nd scenario I want the tittle to be "Revenue by Cities". And it has to be "Revenue by Countries" when all selections are cleared and when there are more than countries. In general tittle should reflect X-axis label. )
Attached is the sample file in which the drill-down has gone directly to State. And it goes to City when a particular State is selected.
Thanks,
Kavita
