12 Replies Latest reply: Feb 23, 2017 6:00 AM by stefano fiemazzo

# Stacked Bar chart with 2 expressions and 2 dimensions

Hi, i want to create a stacked bar chart with 2 expressions (ACT vs BDG) and two dimensions, first one in x axes (BU) and the second one stacked (AREA ICT). I would these two charts in a single one with ACT and BDG side by side:

See qvw attached

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Like this?

Added a new table in the script:

Dim:

Dim

1

2

];

and used it as a dimension

=Pick(Dim, 'ACT', 'BDG')

Expression

Pick(Dim, Sum([BUDGET SENZA MANODOPERA]), sum([BUDGET 2017 (Approvato)]))

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Yess, you are a genius! Can you please reattach me the qvw with solution?

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Very well solved Sunny!

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Thank you

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Hi,

Check this.

Regards,

Kaushik Solanki

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Super Kaushik! Thank you very much!

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Hi, it's possible introduce total? I would 2 bar (one total for Budget and one for Actual)... like this:

thx

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Here is the island dimension solution

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Enabled the Act and Bud labels if that is something you need

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Great! Thank you so much

• ###### Re: Stacked Bar chart with 2 expressions and 2 dimensions

Hi Stefano,

That is not possible with a bar chart; you can show 2 dimensions and 1 expression or 1 dimension and 2 expressions. I think here you have 2 simple possibilities:

• Concatenate 2 dimensions in 1 (=\$(=Only(Dimensione)) & '-' & \$(=Only(Dettaglio))) and show 2 expressions.
• Use a grid chart

I attach a sample of second option.

Regards,
H