0 Replies Latest reply: Mar 24, 2017 11:13 AM by akanksha Patil RSS

    How to add a calculated columns using expression in qlik sense

    akanksha Patil

      Hello,

       

      I am trying to add two columns in my table view as shown below. 

       

       

      For simple addition or subtraction I can add a column  but when I try to calculate percentage for each row by total of that column and use that calculated field again I get error in expression.

       

       

       

      Can anyone please help me with how can I make it in Qlik Sense?

       

       

       

       

      as shown in below table I am trying to add two more columns by performing calculations on existing data

       

      ABCDE
      Unit Name AllocationRevenue% Revenue of total Proposed_Allocation
      Temp 110112C2/(Sum(Revenue)) * 100Sum(Allocation)*D2
      Temp 211114C3/(Sum(Revenue)) * 100Sum(Allocation)*D3
      Temp 312115C4/(Sum(Revenue)) * 100Sum(Allocation)*D4

       

      Thank You