topic Re: Coloring Even and/or Odds in Bar Chart? in QlikView

Coloring Even and/or Odds in Bar Chart?

Thu, 20 Apr 2017 20:26:58 GMT

Hi there, I have the following data:

And I want to use them as BarChart

But I get the data like this:

the Problem is, I need to alter the color between data in any order I decide to sort my itens.

Any Ideas??

The modeling I'm using is:

Dimensions:

1st: Product

2nd: Product_color

Expression:

Sum(Stock)

Sort:

Sum(Stock) DESC

swuehl — Thu, 20 Apr 2017 20:49:52 GMT

Maybe something like this as background color attribute expression

=If( Even(Rowno()) , Darkgray(), lightgray() )

sumitjadhav — Fri, 21 Apr 2017 10:32:08 GMT

Hi apolo takeshi,

I had Tried to solve this issue ,I ended up with this

Expression:

-->> I wrote the Background Expression for Expression as Below,

if(Even([Number of Itens in Stock]),DarkGray(),LightGray())

The Following are the steps:

Write the Stated Expression in Background color properties of Stock.

Output:

Thank's & Regards,

Sumit Jadhav.

Fri, 30 Jun 2017 20:33:39 GMT

hi there! the problem with this solution is that they are not like my "to be" version up there in which I had dark gray, light gray, dark gray...

best!