topic Re: Multi Color Stacked Bar chart in QlikView

Multi Color Stacked Bar chart

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am new to qlikview and currently working on a requirement to represent data as shown in attached snap shot.

In attached snap shot 2 bars are representing 2 metrics.and no dimensions used

1. Available Hours = Sum of Non-Chargeable + Sum of Chargeable Hours

2. Stacked bar chart of Non-Chargeable and Chargeable Hours.

Is there a way to achieve such chart?

Re: Multi Color Stacked Bar chart

engishfaque — Tue, 17 May 2016 17:20:50 GMT

Dear Pradeep,

For stack chart, kindly follow the listed below steps:

Chart Properties > Style Tab > Subtype > Select "Stacked" radio button > Apply > OK.

Kind regards,

Ishfaque Ahmed

Re: Multi Color Stacked Bar chart

Anil_Babu_Samineni — Tue, 17 May 2016 17:39:17 GMT

Please send the qvw file. So that, We can respond back and easy to monitor also....

Re: Multi Color Stacked Bar chart

Tue, 17 May 2016 17:40:40 GMT

Hello Ishfaque,

Thanks for your response. However, my requirement is different here.

I have 2 metrics displaying in the form of bars.

1st bar in the chart indicates metrics 1 (=sum({<[HT] = {'Available'}>}Hours) ).

2nd bar indicates metric 2. But metric 2 aggregation is based on a conditional aggregation. (=sum({<[HT] = {'Non Chargeable','Chargeable'}>}Hours) ).

As metric 1 is derived from a single condition , there needs to be only one color for bar.

But since metric 2 is derived based on 2 values , we need 2nd bar in 2 colors.

Thanks,

Pradeep

Re: Multi Color Stacked Bar chart

swuehl — Tue, 17 May 2016 17:41:18 GMT

To create your total and your detailed bar, you can do something like this:

Create a synthetic dimension like

=ValueList('1','2')

Then three expressions:

=If(ValueList('1','2')= 1, Rangesum(Sum(Value1), Sum(Value2) ) )

=If(ValueList('1','2')= 2, Sum(Value1) )

=If(ValueList('1','2')= 2, Sum(Value2) )

You can hide the dimension label on dimension tab and then set style to stacked on presentation tab.

Re: Multi Color Stacked Bar chart

HirisH_V7 — Tue, 17 May 2016 17:50:56 GMT

Hi,

By using the sample data,

Data:
LOAD * INLINE [
    Non-Chargeble, Chargeable
    1, 2
    2, 1
    4, 2
];

Creating a stacked bar chart using ,

Dimension:-

=ValueList(1,2)

Expressions:-

If(Valuelist(1,2)=2,Sum(Chargeable))

If(Valuelist(1,2)=2,Sum([Non-Chargeble]))

If(Valuelist(1,2)=1,Sum(Chargeable)+Sum([Non-Chargeble]))

stacked chart will look like this,

HTH,

PFA,

Hirish

Re: Multi Color Stacked Bar chart

Tue, 17 May 2016 17:59:29 GMT

Thanks alot Wuehl. This is what i needed. And i followed the approach you mentioned and it is working as expected.

Thanks alot again.