topic Stacked Bar chart with 2 expressions and 2 dimensions in QlikView

Stacked Bar chart with 2 expressions and 2 dimensions

Thu, 16 Feb 2017 10:41:04 GMT

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

sunny_talwar — Thu, 16 Feb 2017 10:50:40 GMT

Like this?

Added a new table in the script:

Dim:

LOAD * Inline [

Dim

];

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

Thu, 16 Feb 2017 10:57:39 GMT

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

Re: Stacked Bar chart with 2 expressions and 2 dimensions

kaushiknsolanki — Thu, 16 Feb 2017 10:58:18 GMT

Hi,

Check this.

Regards,

Kaushik Solanki

Re: Stacked Bar chart with 2 expressions and 2 dimensions

sunny_talwar — Thu, 16 Feb 2017 10:59:24 GMT

Sure

Re: Stacked Bar chart with 2 expressions and 2 dimensions

Thu, 16 Feb 2017 11:03:06 GMT

Super Kaushik! Thank you very much!

Re: Stacked Bar chart with 2 expressions and 2 dimensions

hector_munoz — Thu, 16 Feb 2017 11:13:24 GMT

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

Re: Stacked Bar chart with 2 expressions and 2 dimensions

hector_munoz — Thu, 16 Feb 2017 11:17:47 GMT

Very well solved Sunny!

Re: Stacked Bar chart with 2 expressions and 2 dimensions

sunny_talwar — Thu, 16 Feb 2017 11:51:07 GMT

Thank you

Re: Stacked Bar chart with 2 expressions and 2 dimensions

Thu, 23 Feb 2017 10:42:11 GMT

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

sunny_talwar — Thu, 23 Feb 2017 10:48:30 GMT

Here is the island dimension solution

Re: Stacked Bar chart with 2 expressions and 2 dimensions

sunny_talwar — Thu, 23 Feb 2017 10:54:53 GMT

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

Re: Stacked Bar chart with 2 expressions and 2 dimensions

Thu, 23 Feb 2017 11:00:58 GMT

Great! Thank you so much

Re: Stacked Bar chart with 2 expressions and 2 dimensions

abubakarsiddiq7 — Thu, 13 Jun 2019 13:35:42 GMT

hi sunny ,

the below example din't work out for me could please help me on the requirement.

Requirement:

i have two measures and 2 dimensions(Month and col) .Month is having all the months and colomn1 having yes ,no,# values(ignore #).Expressions are sum(current Year sales ) and sum(Previous Year sales).

i need to built a bar chart with sum(current Year sales ) and sum(Previous Year sales) and on top of this bar need to plat colomn1 field values.

I have implemented but i am getting single expression values .please help me on this

Re: Stacked Bar chart with 2 expressions and 2 dimensions

arusanah — Thu, 18 Apr 2024 18:43:35 GMT

Hi Sunny,

Could you please share example in QVF. I'm trying to implement same in Qliksense app. I am not able to convert your app to QVF.

Thanks

Arusana