4 Replies Latest reply: Oct 15, 2012 3:46 PM by Siva Dandu RSS

    Hello,

    Siva Dandu

      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

          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,
              Siva Dandu

              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?

            • Re: Hello,
              Deepak Vadithala

              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

              • Re: Hello,
                Siva Dandu

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