Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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

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

Thanks @awaisqureshi  for ure help 🙂

View solution in original post

4 Replies
Highlighted
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!

Highlighted
Contributor II
Contributor II

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

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

Thanks @awaisqureshi  for ure help 🙂

View solution in original post