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

    hi all

    surya teja

      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

            Hi,

             

            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.

             

            Regards

            Anand

            • Re: hi all
              Sunny Talwar

              May be something like this?

               

              Capture.PNG

               

              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