5 Replies Latest reply: Sep 17, 2018 10:15 AM by Anil Samineni RSS

    Qlik Sense - How to add calculated field in the WorkSheet

    Tapan Diwanji

      I have a table with customer name, total sales, total expenses. However, I want to add forth column in my worksheet as Profit/Loss by calculating (Total Sales - Total Expenses) for each row. Can someone help me how to do so ?

       

      As is

       

      NameTotal SaleTotal Expense
      Ram5000040000
      Pramod4000020000
      Vijay30005000

      To be

       

      NameTotal SaleTotal ExpenseProfit
      Ram500004000010000
      Pramod400002000020000
      Vijay30005000-2000

       

      **** Please provide me the solution, if I can add calculated measure or not.