topic Re: Calculate net profit in QlikView

Calculate net profit

mustafaelryah — Thu, 29 Jan 2015 09:27:28 GMT

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.

Re: Calculate net profit

arulsettu — Thu, 29 Jan 2015 09:29:01 GMT

try this

in text object

=sum(revenues)-sum(expenses)

Re: Calculate net profit

mustafaelryah — Thu, 29 Jan 2015 09:36:46 GMT

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?!