Stacking 2 bars into 1 with different colours

[#1]

Hi,

Is there any way to stack just 2 bars out of 3.

Please find the qvw I want one Emp total bar and second bar should be Emp status1+Emp Status 2 (the colours should be different).

Thanks,

RK

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[jerem1234]

If I was you, I would remove the expression for Emp total and then just stack the two bars. Since total = empstatus0 + empstatus 1, it would just be the top of the two bars together. If you were to have 2 bars of total and empstatus0 + empstatus1, they would end up having the same height anyway.

[#4]

Thanks Gysbert , Is it possible to get a 3rd bar based on different calculation.

Need 3 bars , 1. total, 2.based on current flag, 3.based on subflag.but the show only for currentflag=1

Please see the qvw.

.