Qlik Sense - How to add calculated field in the WorkSheet

[tdiwanji]

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

Name	Total Sale	Total Expense
Ram	50000	40000
Pramod	40000	20000
Vijay	3000	5000

To be

Name	Total Sale	Total Expense	Profit
Ram	50000	40000	10000
Pramod	40000	20000	20000
Vijay	3000	5000	-2000

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

[felipedl]

HI,

The link that described the creation of calculated dimension is:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Dimensions/calculated-dimensions.h...

[vishsaggi]

Did you try adding this new column profit with expression like below

and what are your expr used for Total Sales and TotalExpenses can you share them?

= YourTotalSalesExpr - TotalExprenseExpr

[tdiwanji]

Tried originally this way only, thinking it as a simple =A-B expression by creating a dimension. However this didn't work. Getting neither results nor error.

[vishsaggi]

‌can I know your expr used for total sales and total expenses?

[Anil_Babu_Samineni]

Thread seems straight forward. What problem and how you are calculating for both?