4 Replies Latest reply: Dec 22, 2016 7:01 PM by John Henry RSS

    How do I create calculations in QlikSense?

    John Henry

      I'm new to QlikSense and I'm trying to add a % of total column in a Pivot table I have created.  I have used the Measures feature to do basic "sum" formulas (e.g., for sales), but not sure how to create a % Mix based on each rows value relative to the whole dataset.

       

      Here's a very basic illustration of what I'm trying to do:

       

         

      ProductSales% Mix
      A $             5 14%
      B $          10 29%
      C $          20 57%

       

       

      Something tells me the answer is to use Expressions, but I'm not familiar with the language/syntax

       

      Thanks for your help!