topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Mon, 05 Oct 2015 20:26:16 GMT

Hello all,

I am trying to make this bar chart:

The escapes and catches each have two different expressions, so it is not working properly.

The escape's definition is: if(DEPT<>F_DEPT,SUM(REJECT_QTY))

Whereas the Catches definition is if(DEPT=F_DEPT,SUM(REJECT_QTY)).

Does anyone know how to do this?

MarcoWedel — Mon, 05 Oct 2015 20:30:11 GMT

‌Hi,

please post sample data/app to demonstrate with.

regards

Marco

Clever_Anjos — Mon, 05 Oct 2015 21:11:30 GMT

Please adjust your expressions and set "stacked" at Style tab

SUM( if(DEPT<>F_DEPT,REJECT_QTY))

SUM( if(DEPT=F_DEPT,REJECT_QTY))

jonas_rezende — Mon, 05 Oct 2015 21:19:57 GMT

Hi, Channing Dionisopoulos.

Try

Escape = Sum({<DEPT = {"=Sum(if(DEPT <> F_DEPT,REJECT_QTY))"}>} REJECT_QTY)

Catch = Sum({<DEPT = {"=Sum(if(DEPT = F_DEPT,REJECT_QTY))"}>} REJECT_QTY)

Hope this helps!

MarcoWedel — Mon, 05 Oct 2015 22:16:19 GMT

Hi,

possible solutions could be also:

reducing your expression to simply

hope this helps

regards

Marco