4 Replies Latest reply: Nov 3, 2015 4:07 AM by Homer Cruzado RSS

    Calculating Percentage Per Month

    Homer Cruzado

      Hi all,

       

      Below is the table I want to achieve in QlikSense.  I'm having troubles doing the computation for the "%" column per month.

      sample.PNG

      The field ReportMonth was defined in the loadscript to be Month with the format 'MMM-YY'

       

      I've already tried the following syntax..

       

      sum(Output) / sum(TOTAL Output)

      sum(Output) / sum(TOTAL {<ProductType>} Output)

      sum(Output) / sum(TOTAL {<ReportMonth>} Output)

      sum(Output) / sum(TOTAL {<ReportMonth,ProductType>} Output)

       

      Thanks!