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.

[Gysbert_Wassenaar]

1. On the Visual Cues tab of the properties screen you can set different colors for values larger and/or smaller than values you set there.

2.  sum( {$<Month = {$(=Only(Month))}>} Sales ) - sum( {$<Month = {$(=Only(Month)-1)}>} Sales )

[IAMDV · Accepted solution]

Hi Sivadandu,

As suggested by Gysbert... you can use Visual Cues but that is old fashioned way. Rather I'd recommend you to use Text Colour under expressions sign. I've made a video tutorial on how to use experssion attributes. Here is the link...please let me know if you need more information.

http://qlikshare.com/328

Cheers,

DV

[#4]

Your postings are really helpful.... Hatsoff.......

[#5]

Thanks a lot....... for your time and reply...

Your answer is really helpful....But did not get oppertunity to work on that today.... May be i  will reply to you tomorrow with good news. I think i have to change the month field. Its in text format now....(ex,, 'Mar','Apr','May'....).

Iam not sure, how (Month-1) works in my case?