3 Replies Latest reply: Jun 2, 2016 3:26 PM by Ugonna Okoli RSS

    Divide column values by a variable

    Ugonna Okoli

      Hi All,

       

      Is it possible to add a calculated column to a table object in Qlik Sense? I've been spinning my wheels for a bit and could use some help. Here's my scenario and attempted solution

       

      Scenario: Say I have a dataset with a couple columns 'Process' & 'Count', and I want to display the count of each process as a percentage of the total count in a column as shown below;  

      ProcessCountPercent
      A533.33%
      B16.67%
      C320.00%
      D426.67%
      E213.33%


      Attempted Solution: Declare the total count as a variable(SumCount), then create a measure with expression (Count/$(SumCount))*100. This doesn't work, it gives a column with all 100 values.

      Attached is a sample qvf.

       

      Thanks!