6 Replies Latest reply: Nov 22, 2017 6:35 AM by saad zaman RSS

    Calculating Percentage Per Month

      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!