topic Re: Hello, in QlikView

Hello,

Sat, 13 Oct 2012 12:05:39 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,

Gysbert_Wassenaar — Sat, 13 Oct 2012 15:09:10 GMT

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 )

Re: Hello,

IAMDV — Sun, 14 Oct 2012 11:39:25 GMT

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,

Re: Hello,

Mon, 15 Oct 2012 19:42:10 GMT

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

Re: Hello,

Mon, 15 Oct 2012 19:46:21 GMT

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?