Chart Drill-Down

Mon, 16 Jun 2014 15:53:39 GMT

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

Re: Chart Drill-Down

eduardo_sommer — Mon, 16 Jun 2014 16:39:35 GMT

You can use as your chart title the expression

=GetCurrentField([New Group])

This will change the caption of the chart whenever you change the drilldown level.

Eduardo

Re: Chart Drill-Down

Tue, 17 Jun 2014 04:53:43 GMT

Thanks a lot Eduardo

topic Chart Drill-Down in QlikView

Chart Drill-Down

Re: Chart Drill-Down

Re: Chart Drill-Down