Hello,

[#1]

Hello,

am new to Qlikview. Would you please any one help me on these following issues.

1>   How to set different colors for the positive and negative values in the bar chart over a period of time ( Month is dimension)

2> How to write an  expression for the difference of sum(sales) for all months  ( Month is dimension, sum(sales) is expression)

ex: for the month for Feb'12, the expression should be difference of sum of Feb12 sales and sum of Jan12 sales.

Dimension : Month

Expression : Difference of sum (sales) with previous month.

[#2 · Accepted solution]

hi Sivadandu,

1. When you wright an expression in expression tab there is + sign in front of expression, expend this + sign and then chouse "Background Color" wright your condition in definition box like

if(sum(sales) < 50, rgb(255,0,0), rgb(0,128,0) )

2. you can use solution given by Mr. Gysbert Wassenaar

Hope it will help

Regards

- Anil