Double stack bars chart with 2 lines

[#1]

Hi,

Please refer to attached image... I currently have 2 seperate combo charts (stack bars + line)... Scales are different for both the charts. First one is about ACU (asset consumption) which is calculated with value under 1 whereas second chart is about revenue in '000s.

Both the charts have single dimension - CalendarMonthName. And 4 expressions - 3 for stack bars and 4th for average line.

Now our requirement is to combine both the charts together... So for every month, I should have 2 bars next to each other - one for ACU and other for Revenue. ACU should be positioned to left (as it is currently), whereas Revenue should be positioned to right (instead of currently positioned to left) "stacking" should happen independantly for ACU and for Revenue.

Lines are calculated expressions for monthly averages.. .one line should be for ACU and other for Revenue..

So far I tried 2 approaches -

1) Kept a single dimension as CalendarMonthName. And added 8 expressions. ACU expressions are positioned to left and Revenue to right. This approach did not plot stack bars for ACU.

2) Added a new dummy dimension using ValueList("ACU", "Revenue") but this also cannot be used since the underlying scales are different..

Can someone please help?! thanks in advance!

[fosuzuki]

Hi,

1. go to Chart Properties > Axes > Expression Axes > Expressions, and select the expression you want to change the scale side

2. in this same tab, select Position > Right.

Hope this points you in the right direction.

Regards,

Fernando

[#3]

Hi Fernando,

thanks for replying..

as mentioned in my post, I did try that option.. but unfortunately the chart only shows a single stacked bar instead of two..

[fosuzuki]

Sorry, I didn't pay enough attention to you text....

Can you send a qvw with sample data and the graphs you did? I think this is an easier way to try to help you...

Regards,

Fernando

[matt_crowther]

As I suspected: 'valuelist() to the rescue!' - check out the attached post:

http://community.qlik.com/message/156956#156956

This solves your inherent problem in that you need to assign expressions to different stacks by creating synthetic dimensions.

Hope that helps,

Matt - Visual Analytics Ltd