Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

Re: histogram chart in QlikView

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

Highlighted
Contributor II
Contributor II

Re: histogram chart in QlikView

Thanks @awaisqureshi  for ure help 🙂

View solution in original post

4 Replies
Highlighted
Contributor III
Contributor III

Re: histogram chart in QlikView

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!

Highlighted
Contributor II
Contributor II

Re: histogram chart in QlikView

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

Highlighted
Contributor III
Contributor III

Re: histogram chart in QlikView

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

Highlighted
Contributor II
Contributor II

Re: histogram chart in QlikView

Thanks @awaisqureshi  for ure help 🙂

View solution in original post