topic profit calculation require from two column in QlikView

profit calculation require from two column

yadav_anil782 — Tue, 09 Jun 2015 08:34:13 GMT

Dear All ,

i have value againsed time series(year, month, quarter, day) and other dimentions wise . now i want "actual profit amount" from "Received Collection"- "outgoing amount" with logic(Received Collection-outgoing amount+ previs amount ) . this logic i attched in excel sheet .

plz helt to create this logic , i need to show this column in dashboard as a line chart

note- both column belongs to difrent tables

Year	Received Collection	outgoing amount	profit amount	actual profit amount
2009	0.00	0.01	-0.01	-0.01
2010	1,421.04	1,643.10	-222.06	-222.07 logic-(1,643.10-(-222.06)+-0.01
2011	441.75	3,083.95	-2,642.20	-2,864.26
2012	651.47	2,182.35	-1,530.88	-4,395.15
2013	868.57	1,572.27	-703.70	-5,098.85
2014	1,326.99	3,194.92	-1,867.93	-6,966.77
2015	259.70	877.47	-617.77	-7,584.54

Re: profit calculation require from two column

MayilVahanan — Tue, 09 Jun 2015 09:42:15 GMT

PFA

Re: profit calculation require from two column

yadav_anil782 — Tue, 09 Jun 2015 10:10:15 GMT

HI,

WHERE IS YOUR SOLUTION , I'M NOT ABLE TO FIND

Re: profit calculation require from two column

yadav_anil782 — Mon, 15 Jun 2015 13:05:58 GMT

Hi Mayil,

your rvert is helpful , i need again calculation in same line chart

i want future profit line in chart with the help of given "future collection" column ,

present logic is - =([Received Collection]-[Paid Amount])+Alt(Above([Net Amount]),0)

now i want continuew this line for future profit also so i'm giving this expression =([Received Collection]-[Paid Amount])+Alt(Above([Net Amount]),FINAL_AMOUNT-[Net Amount])