Bar chart With Two dimension

[#1]

Hi All,

I want to create a bar chart with 2 dimension & two expression. One expression should be stacked sub type & other expression should be grouped subtype.

Any help would be appreciated.

[tresesco]

I am afraid that, this would not be possible in one chart here in qv.

[#3]

I don't know how to achieve it in qv, but in excel it's achievable to overlap these two chart type together and keep the front one to be transparent.

[selvakumarsr · Accepted solution]

To my knowledge this is not possible in QV...

[#5]

The same thing do in the qlikview create two different charts for each and set the transparency 100% and overlap them..

[#6]

yes we can overlap both graph & set transparency to 100% but then dimession will repeat two times,

one for stacked expression & one for grouped expression.

[#7]

Okay then hide the dimension of one chart labeling it by space.. try this

[#8]

Bhawna I did as you say, but if i remove dimension name ,then how one come to know which expression belong to which dimension....

[#9]

It seems you want a line and bar chart,there is a combo chart option,I have created a sol sample have a look...

[#10]

It`s not have any data,

please share Budget.xls