4 Replies Latest reply: Sep 27, 2017 7:39 AM by Anil Babu Samineni RSS

    Calculate Market Share in Qlik sense Chart

    vikas mahajan

      Dear All

       

      I am calculating Market share using  this formula

      num(Sum({$<Company ={'BPC'}>} [VolKL])/vBPCLVolKL,'##.#'& '%')

       

      Where Variable is  vBPCLVolKL =Sum( Total  <CalendarDay>  {$<COMP ={'BPCL'}>}  [VolKL])

      using this i am just getting 82.8 % which should be 100%  what could be mistake ?

       

       

      When i am using  following I am getting correct  and following highlighted  i want to store in variable.

       

      num(Sum({$<Company ={'BPC'}>} [VolKL])

          /Sum(TOTAL {$<Company ={'BPC'}>} [VolKL]),'##.#'& '%')

       

      Thanks in adv

       

      Vikas