Hello,

Sat, 13 Oct 2012 11:58:22 GMT

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.

Re: Hello,

Sat, 13 Oct 2012 18:20:45 GMT

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

topic Hello, in QlikView

Hello,

Re: Hello,