topic Visual cues in bar charts in QlikView

Visual cues in bar charts

Fri, 09 Dec 2011 09:21:41 GMT

Hello All,

I am trying to make a bar chart having two different colors on basis of months

Example: I want to create a sales report with Year , Month, Date in one Dimension Group and want to visualize bars half yearly, suppose, bars for jan to june should be of blue color and from july to dec should be of red color.

Is it possible to create this type of color patterns.

It would be a great help to figure out this.

Thanks in advance.

Visual cues in bar charts

Fri, 09 Dec 2011 09:27:30 GMT

Hi Nitin

Why donot you use expressions to control conditional formatting.

Visual cues in bar charts

Sun, 11 Dec 2011 16:29:14 GMT

Dear All,

Please help me out with the matter.

It will help me a lot while developing my appppp.....

Thank you

Visual cues in bar charts

Sun, 11 Dec 2011 17:57:02 GMT

Yes it's possible

cliq in the '+' at the right of the expression

Then in the background color create an expression such :

=if( Month <= 6 , color(1) , color(2)) color(n) is the nth color in the color panel. Adapt to your needs