Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mustafaelryah
Creator
Creator

Calculate net profit

Dear All,

     I have chart that shown all expenses vs all revenues , I need to show (revenues - expenses) on Text Object.

My dimension is account type , my expression calculate only summation of expenses or summation of revenues.

2 Replies
arulsettu
Master III
Master III

try this

in text object

=sum(revenues)-sum(expenses)

mustafaelryah
Creator
Creator
Author

Kindly see how I calculated the  expenses and revenues

=if ( Account_Type2<> 'Equities' and  Account_Type2<> 'Assets' and Account_Type2 <> 'Other' and Account_Type2 <> 'Liabilities',if(Sum(debit) - sum(credit)>=0,Sum(debit) - sum(credit),-1*(Sum(debit) - sum(credit))))

and what can I do on text object?!