bar chart drill down

[#1]

Hi All,

I have a bar chart having dimension with 3 drill-downs. When I drill down to second level I want to display the first value. Similarly When I drill down to 3rd level I want to display 2nd level value.

For Ex: say drill downs are County,State,City

When I drill down from Country to State(by clicking on a Country) I want to show the country which was selected.

And when I drill down from State to City(by clicking on a State) I want to show the State which was selected.

Can anybody tell me how to do this??

Thanks in advance.

[vgutkovsky]

When you say "display" I'm assuming you just mean as text in the chart? You can add text in chart under the Presentation tab. Then, if your group is called d_Geo for example, the syntax would be:

=pick(match(getcurrentfield(d_Geo),'Country','State','City'),

         ' ',

         only(Country),

         only(State)

)

Regards,

Vlad

[#3]

Hi Vlad,

Thanks for the reply.

I tried using the expression you have give. But its not working.

I'm new to qlikview, Can you please explain what does that expression do?

Thanks

[vgutkovsky]

You would, of course, need to replace the values in my expression with your real values. So change "d_Geo" to your real group name. Similarly, if your country field is called My Country, replace 'Country' with 'My Country' etc.

Regards,

Vlad