7 Replies Latest reply: Jan 23, 2018 4:41 AM by Sunny Talwar RSS

    YoY Market Share Calculation in qlik sense

    vikas mahajan

      hi all,

       

      I am calculating market share formula using dimension Company & fiscal year

       

      Expression:

       

      (((SUM({$<COMP=,FiscalYear={$(=max(FiscalYear))}>} Y2Sale))/$(vvTotalY2Sale))*100)

       

      Variable Declared

      vvTotalY2Sale is variable : SUM({$<FiscalYear={$(=max(FiscalYear))}>} TOTAL [Y2Sale])  (total of all Compaies)

       

      I am getting output attached which is correct for one fiscal year 2018 , in my data I have data from 2011. How to show this all fiscal year market share like 2011.... to 2018 companywise?

       

      Vikas