topic Re: Bar Chart Color -> above and below Value in QlikView

Bar Chart Color -> above and below Value

Anonymous — Mon, 30 Nov 2015 11:01:01 GMT

Hi,

i want to create a chart like this:

I think i could create this with a stacked bar chart.

But i dont know how to apply different colors according to being above/below plan value.

Does someone has already implemented something like that?

Phil

Re: Bar Chart Color -> above and below Value

tresB — Mon, 30 Nov 2015 11:19:04 GMT

See attached sample qvw

Re: Bar Chart Color -> above and below Value

swuehl — Mon, 30 Nov 2015 11:22:57 GMT

Maybe like attached?

Two expressions in a stacked bar chart:

=Rangemin(sum(Expression3), vThreshold)

=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)

Re: Bar Chart Color -> above and below Value

Anonymous — Mon, 30 Nov 2015 12:12:45 GMT

Hey thanks guys! That really helps me.

But how can i change the expression to geht it in another color if its below plan?

Re: Bar Chart Color -> above and below Value

tresB — Mon, 30 Nov 2015 12:16:17 GMT

Could you post your sample qvw ?

Re: Bar Chart Color -> above and below Value

swuehl — Mon, 30 Nov 2015 12:17:56 GMT

Open the expression attributes of the first expression by clicking on the small plus sign next to the expression label on upper left corner of expression tab.

Then edit the background color attribute expression:

=Black()

Re: Bar Chart Color -> above and below Value

jonathandienst — Mon, 30 Nov 2015 12:25:13 GMT

Three expressions in a stacked bar chart:

=Rangemin(sum(Expression3), vThreshold)

=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)

=if(sum(Expression3)<vThreshold, vThreshold-sum(Expression3))

Re: Bar Chart Color -> above and below Value

HirisH_V7 — Mon, 30 Nov 2015 12:29:51 GMT

Hi,

PFA,

For Line and Mutlicolored Stacks .

I hope this Helps,

Regards,

Hirish.

Re: Bar Chart Color -> above and below Value

Anonymous — Mon, 30 Nov 2015 12:40:55 GMT

Hi Jonathan,

thats the right answer!

Thanks alot!

Phil

Re: Bar Chart Color -> above and below Value

Anonymous — Mon, 30 Nov 2015 14:21:34 GMT

Got another requirement.

So far it looks like:

If I select more than one Year it looks like:

How can i get this to show grouped? I guess thats not possible?

At the moment ive got one expression for each year.

Re: Bar Chart Color -> above and below Value

swuehl — Mon, 30 Nov 2015 14:24:01 GMT

Not sure if I understand what you want to group here. Sample lines of data or a small sample QVW always help to understand where you are coming from.

Potentially, you can add more expressions to stack upon your bars.

Re: Bar Chart Color -> above and below Value

Anonymous — Thu, 03 Dec 2015 09:08:00 GMT

Forget my last posting. Im ok with that now