Displaying Stacked & unstacked bar on a same chart

[sureshbaabu]

Hello,

I would like to check if we can display a 2 bars – one normal bar and the second as a stacked bar

In my example; I have Tools, Team and the Headcount.

I wanted to display the Headcount of Team - T1’ in one bar(1^st Bar) and the Headcount of other Teams T2,T3&T4 on a stacked bar (2^nd Bar) against the ‘Tools’ (Dimension)

Please refer the attached screen shot for the expected output.

Data set:

Tools	Team	Headcount
Qlikview	T1	4
Tableau	T1	5
Soptfire	T1	6
OBIEE	T1	4
Qlikview	T2	5
Tableau	T2	7
Soptfire	T2	4
OBIEE	T2	6
Qlikview	T3	2
Tableau	T3	7
Soptfire	T3	3
OBIEE	T3	2
Qlikview	T4	1
Tableau	T4	1
Soptfire	T4	9
OBIEE	T4	4

Thank you!!!

[MK_QSL]

As far as I know, there is no such an option in QlikView to show one expressions as single and other as stacked in bar chart.

[giakoum]

unless you place one chart over the other...

[Gabriel]

Hi,

What I can suggest is to have 2 bar chart, 1 normal and the other stack, opposite each other almost like column. What you will have to do is to use condition in the charts to pick up and display the charts as preferred, stack and normal bar chart.

Hope this makes sense

Gabriel

[sureshbaabu]

Thanks for your thoughts!!

I'm sure it's hard to acheive. But will wait to hear some other alternatives from Others