Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Hello,

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.

1 Solution

Accepted Solutions
dvqlikview
Honored Contributor II

Re: Hello,

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 Replies

Re: Hello,

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 )


talk is cheap, supply exceeds demand
dvqlikview
Honored Contributor II

Re: Hello,

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

Not applicable

Re: Hello,

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

Not applicable

Re: Hello,

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?

Community Browser