topic Horizontal stacked bar chart with one dimension in QlikView

Horizontal stacked bar chart with one dimension

Thu, 14 Jul 2016 16:34:22 GMT

Hi,

I have one dimension which is product type and I need to show the sum of each product type in a horizontal stacked bar chart with only one bar. Please see example below.

Anyone could help with this?

Many Thanks

Paulo

Re: Horizontal stacked bar chart with one dimension

NickHoff — Thu, 14 Jul 2016 17:02:38 GMT

Dimension: ProductType

Expressions use show value on data points, and bar options:

SUM({$<ProductType = {'A'}>}ProductType)

SUM({$<ProductType = {'B'}>}ProductType)

SUM({$<ProductType = {'C'}>}ProductType)

SUM({$<ProductType = {'D'}>}ProductType)

On the style tab select stacked sub-type.

Re: Horizontal stacked bar chart with one dimension

Thu, 14 Jul 2016 17:33:30 GMT

Hi Nick

Thanks for your reply.

Unfortunately didn't work. It will create 4 bars in the chart (one by expression).

The objective is to SUM the Number of products by product type and show it in one column only. (like the image above)

Any ideas?

Thanks

Paulo

Re: Horizontal stacked bar chart with one dimension

NickHoff — Thu, 14 Jul 2016 18:23:27 GMT

Create a PICK into one expression.

Use an Inline table to generate the description of product type, and an id for each one. The order of the PICK is the order of your id(s).

PICK(PickProductTypeId,

SUM({$<ProductType = {'A'}>}ProductType),

SUM({$<ProductType = {'B'}>}ProductType),

SUM({$<ProductType = {'C'}>}ProductType),

SUM({$<ProductType = {'D'}>}ProductType),

)

Re: Horizontal stacked bar chart with one dimension

NickHoff — Thu, 14 Jul 2016 18:29:40 GMT

Forgot to mention your dimension would be your PickProductTypeDescription that you created in the inline table, like the following.

ProductTypePick:

LOAD * INLINE [

%PickProductTypeID, %PickProductTypeDescription

1, A

2, B

3, C

4, D

];

The above will still give you 4 different dim values, so you'd have to add a 3rd field like the following and use the 3rd field for your Dim:

ProductTypePick:

LOAD * INLINE [

%PickProductTypeID, %PickProductTypeDescription, '%PickAggrDesc

1, A, ProductType

2, B, ProductType

3, C, ProductType

4, D, ProductType

];

Re: Horizontal stacked bar chart with one dimension

MarcoWedel — Thu, 14 Jul 2016 22:25:58 GMT

Hi,

one solution might be:

hope this helps

regards

Marco

Re: Horizontal stacked bar chart with one dimension

Fri, 15 Jul 2016 15:38:07 GMT

Hi Marco,

Works perfect. Thats is exactly what I looking for.

Many Thanks

Paulo

Re: Horizontal stacked bar chart with one dimension

Fri, 15 Jul 2016 15:41:33 GMT

Hi Nick,

I have tested this approach and it works as well.

Many thanks for you support.

Paulo

Re: Horizontal stacked bar chart with one dimension

MarcoWedel — Fri, 15 Jul 2016 21:46:55 GMT

you're welcome

glad it worked

regards

Marco