topic Re: Stacking 2 bars into 1 with different colours in QlikView

Stacking 2 bars into 1 with different colours

Thu, 18 Jul 2013 19:04:21 GMT

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,

Re: Stacking 2 bars into 1 with different colours

Gysbert_Wassenaar — Thu, 18 Jul 2013 19:18:11 GMT

See attached example.

Re: Stacking 2 bars into 1 with different colours

jerem1234 — Thu, 18 Jul 2013 19:21:09 GMT

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.

Re: Stacking 2 bars into 1 with different colours

Thu, 18 Jul 2013 20:30:16 GMT

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.