topic Re: histogram chart in QlikView in QlikView

histogram chart in QlikView

airammej — Sat, 16 Nov 2024 03:00:11 GMT

Hi every One

I want to divise a bar in Histogram to three sections :

Re: histogram chart in QlikView

awaisqureshi — Mon, 15 Jul 2019 17:58:46 GMT

Hi @airammej,

Maybe you can try something like this on a stacked bar chart:

Expression 1:

if(StockValue>SS,SS,StockValue)

Expression 2:

if(StockValue>SS+Q,Q,StockValue)

Expression 3:

if(StockValue>SS+Q,StockValue-SS-Q)

You can assign each of these expressions the desired color and it should look similar to what you are looking for. Let me know if this works for you!

Re: histogram chart in QlikView

airammej — Tue, 16 Jul 2019 09:21:14 GMT

Thanks @Awaisqureshi for your answer i have 3 expressions like is mentionne in my Screen(1) under stock/ inv .On Hand /Cycle Stock / Over Stock and i add références lines to my chart screen (2) ==> screen (3) so i still have the same issue

Re: histogram chart in QlikView

awaisqureshi — Tue, 16 Jul 2019 14:54:12 GMT

I think what you're missing is different colors for each of those expressions. If you click the '+' you can input a background color.

Let me know if I'm misunderstanding your request.

Re: histogram chart in QlikView

airammej — Wed, 17 Jul 2019 11:58:52 GMT

Thanks @awaisqureshi for ure help 🙂