topic Displaying Stacked & unstacked bar on a same chart in QlikView

Displaying Stacked & unstacked bar on a same chart

sureshbaabu — Thu, 13 Feb 2014 13:15:32 GMT

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!!!

Re: Displaying Stacked & unstacked bar on a same chart

MK_QSL — Thu, 13 Feb 2014 13:28:01 GMT

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.

Re: Displaying Stacked & unstacked bar on a same chart

giakoum — Thu, 13 Feb 2014 13:33:03 GMT

unless you place one chart over the other...

Re: Displaying Stacked & unstacked bar on a same chart

Gabriel — Thu, 13 Feb 2014 13:45:53 GMT

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

Re: Displaying Stacked & unstacked bar on a same chart

sureshbaabu — Thu, 13 Feb 2014 14:06:20 GMT

Thanks for your thoughts!!

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