3 Replies Latest reply: Feb 10, 2016 4:15 AM by Sunny Talwar RSS

    hi all

      i have a line chart that consists year on year data but i want to show the difference of that both years in the same chart wiht an expression can anyone please give a solution for that.


      thanks in advance

        • Re: hi all
          Manish Kachhia

          Hi Surya,

          1) Request you to post a question which some meaningful subject so that it would help others while searching.

          2) If you can provide some more information, I am sure you will get good/correct answer, as your question is similar to many questions covered more than 100 times in QlikCommunity.


          Happy Qliking !

          • Re: hi all
            Anand Chouhan



            Dont be in a hurry try to write meaning ful heading for your question try to edit your heading.

            Also represent your question with some example or the daigrams.




            • Re: hi all
              Sunny Talwar

              May be something like this?




              Here the bar is the difference in dollar terms and Difference % is the % change from last year. Expressions for them are:

              Difference: =Sum(Sales)-Above(Sum(Sales))

              Difference %: =Sum(Sales)/Above(Sum(Sales)) - 1