topic Re: Problem with Colors in a Bar Chart in QlikView

Problem with Colors in a Bar Chart

Fri, 02 Nov 2012 19:29:48 GMT

I have problems to add some color to the bar chart. I'm placing the following expression in the "Background Color".

if (fabs ((Sum (MIX)-sum (Plan)) / Sum (MIX))> 0.25, lightred (), lightblue ())

The main expression is

fabs ((Sum (MIX)-sum (Plan)) / Sum (MIX))

and has marked the "Relative".

But it does not work properly

MayilVahanan — Fri, 02 Nov 2012 19:43:07 GMT

if (fabs ((Sum (MIX)-sum (Plan)) / Sum (total MIX)) > 0.25, lightred (), lightblue ())

give original value for comparison, not relative value(0.25)..

hope it helps

Fri, 02 Nov 2012 20:14:55 GMT

Actually, red coloring need all bars that exceed the value of the variable VMetaMAPE.

Attached the example

swuehl — Fri, 02 Nov 2012 20:30:02 GMT

Try for the background color attribute expression:

if (fabs((Sum(MIX)-sum(Plan))/Sum(MIX)) / sum(total aggr(fabs((Sum(MIX)-sum(Plan))/Sum(MIX)),MesAño))

> VMetaMAPE, lightred (), lightblue ())

Fri, 02 Nov 2012 20:36:08 GMT

Sorry, but still not working

MayilVahanan — Fri, 02 Nov 2012 20:38:21 GMT

PFA

Edit:

Mr.Swuehl expression works well.. Same only i used in demo application..

Fri, 02 Nov 2012 20:59:44 GMT

As the expression would be if in the same example, instead of using the dimension MonthYear (MesAño) use a hierarchical group of Year, Month.

Thanks

Sat, 03 Nov 2012 05:09:18 GMT

Hi All,

Mr. Mayil Vahanan Sir It is absolutely working. I Dont know why it is not working for zenigarcia.

Regards,

Nirmal.

Sat, 03 Nov 2012 12:50:00 GMT

Sorry for not warning. If it works well only nowI have anotherrequirementis that the expression

work but whose dimension is a hierarchical group of Year and Month.