topic Re: Dynamical coloring of bar chart in QlikView

Dynamical coloring of bar chart

carolin01 — Thu, 30 Jun 2016 10:27:59 GMT

Hi,

I´ve a bar chart where I first had two expressions:

Expression in Gray:

=Num(Sum({$<LastMonthDayMarker = {'>=1'}, BacklogMarkerThis = {'1'} , OrderPhase_Desc = {'HISBACKLOG'} >} NettAmount$(vCurrency)),$(vInteger))

Expression in Blue:

=Num(Sum({$<FYear = {'$(=vFYToday)'} , OrderPhase_Desc = {'Revenue'} >} NettAmount$(vCurrency)), ''),$(vInteger))

Now what I actually want is a conditional background formatting of the currently blue bar. The gray bar is actually a part of it. I tried them to just overlap and I couldn´t find how. Now I just try to give that blue chart two colors. Gray for the first section of the bar until it is as high as the gray one and for the rest blue.

My expression that I tried up to now is:

if( (Sum({$<LastMonthDayMarker = {'>=1'}, BacklogMarkerThis = {'1'}, OrderPhase_Desc = {'HISBACKLOG'} >} NettAmount$(vCurrency))) ={'>=1'}, rgb(0,94,187), rgb(89,89,89))

I think the expression doesn´t express that the color of the bar should be divided. Right now it only says if it higher than 1, then make it blue otherwise gray. What do I need to write?

Many thanks in advance!

Re: Dynamical coloring of bar chart

migueldelval — Thu, 30 Jun 2016 10:41:25 GMT

Hi Caroline,

I think that you can´t use two colurs for one expression. Maybe you can use two Expressions and use diferents colurs and group it.

But I´m going to look for information about it.

Regards

Miguel dle Valle

Re: Dynamical coloring of bar chart

marcus_sommer — Thu, 30 Jun 2016 11:19:24 GMT

Maybe an approach like this: Re: Highlighting particular week or range of time in stack bar chart or 2 dimension line chart could be helpful. Whereby it's rather an ugly job to fiddle this to an acceptable view.

- Marcus

Re: Dynamical coloring of bar chart

carolin01 — Thu, 30 Jun 2016 13:15:41 GMT

Hi Miguel,

ok, thank you! It would also work if they could just overlap. I also coulnd´t find how to do this... I check with a combo chart now, maybe this gives me other options.

Best regards

Carolin

Re: Dynamical coloring of bar chart

sunny_talwar — Thu, 30 Jun 2016 13:34:27 GMT

Can you try using a stacked bar chart with these expressions:

Expression in Gray (Stays the same)

=Num(Sum({$<LastMonthDayMarker = {'>=1'}, BacklogMarkerThis = {'1'} , OrderPhase_Desc = {'HISBACKLOG'} >} NettAmount$(vCurrency)),$(vInteger))

Expression in Blue (Blue - Gray)

=Num(Sum({$<FYear = {'$(=vFYToday)'} , OrderPhase_Desc = {'Revenue'} >} NettAmount$(vCurrency)) - Sum({$<LastMonthDayMarker = {'>=1'}, BacklogMarkerThis = {'1'} , OrderPhase_Desc = {'HISBACKLOG'} >} NettAmount$(vCurrency)),$(vInteger))

Gray bar as first expression

Blue - Gray as second expression

Re: Dynamical coloring of bar chart

Thu, 30 Jun 2016 14:35:38 GMT

Hi Carolin

You can try the "Bar Offset" property of the expression. See my example with a third bar where the offset is the expression of the first bar.

Best regards,

Marcello

Re: Dynamical coloring of bar chart

carolin01 — Fri, 01 Jul 2016 10:16:13 GMT

I didn´t try this one but I think this could have worked as well for me.

Re: Dynamical coloring of bar chart

carolin01 — Fri, 01 Jul 2016 10:17:18 GMT

This was correct. I use it in this way now. I think I had concerns because I didn´t want to make it too complex but at the end it´s only important for the user that it is working well.

Re: Dynamical coloring of bar chart

carolin01 — Fri, 01 Jul 2016 10:18:00 GMT

This was the right track. Thank you 🙂