How to change orientation of Qlikview chart in hierarchy

[#1]

‌Hi all

i I am hoping that you help me with understanding how to change the orienthation of a chart based upon the hierarchy level Displayed.

My chart has  a 5 level hierarchy that allows users to drill down to the most granular data. The chart at level 1 has only two vales and looks better as a vertical bar chart. However once you start to drill down the chart it would be displayed better as a horizontal chart.

How can I change the property of the chart based on the level within my hierarchy to change from vertical to horizonta.

I Have considered two charts as an option but unsure which condition / expression to use To switch between the two.

Hopefully someone has already done this or can suggest a way for me to try. If you have a simple example that would be perfect.

Thanks

Keith

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be:

hope this helps

regards

Marco

[#3]

Sorry for delay and yes it helped alot

Thanks

Keith

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .