Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
airammej
Contributor II
Contributor II

histogram chart in QlikView

Hi every One 

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

2019-07-15_16h44_03.png

Labels (2)
2 Solutions

Accepted Solutions
awaisqureshi
Contributor III
Contributor III

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.

 

Color.png

View solution in original post

airammej
Contributor II
Contributor II
Author

Thanks @awaisqureshi  for ure help 🙂

View solution in original post

4 Replies
awaisqureshi
Contributor III
Contributor III

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!

airammej
Contributor II
Contributor II
Author

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

capt1.png

 

 

capt2.pngcapt3.png

awaisqureshi
Contributor III
Contributor III

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.

 

Color.png

airammej
Contributor II
Contributor II
Author

Thanks @awaisqureshi  for ure help 🙂