1 Reply Latest reply: May 31, 2018 4:19 AM by Gysbert Wassenaar RSS

    Market Share Difference

    Mariam Ovasheli

      Hello, I want to calculate market share difference Within Quarters and can you please tell me How ?

       

      sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>}Volume)

      /

      sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>} TOTAL Volume)


      I need To Write Something like This

        • Re: Market Share Difference
          Gysbert Wassenaar

          perhaps like this:

           

          (sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>}Volume)

          /

          sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>} TOTAL Volume))

          -

          above(

          sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>}Volume)

          /

          sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>} TOTAL Volume)

          )


          If that doesn't work then please post a small qlik sense app with some example data.