topic Re: bar chart drill down in QlikView

bar chart drill down

Tue, 10 Dec 2013 13:09:49 GMT

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.

Re: bar chart drill down

vgutkovsky — Tue, 10 Dec 2013 18:19:51 GMT

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

Re: bar chart drill down

Wed, 11 Dec 2013 05:10:46 GMT

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

Re: bar chart drill down

vgutkovsky — Thu, 12 Dec 2013 17:35:51 GMT

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