Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
yadav_anil782
Creator II
Creator II

profit calculation require from two column

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    

YearReceived Collectionoutgoing amountprofit amountactual profit amount
20090.000.01-0.01-0.01
20101,421.041,643.10-222.06-222.07  logic-(1,643.10-(-222.06)+-0.01
2011441.753,083.95-2,642.20-2,864.26
2012651.472,182.35-1,530.88-4,395.15
2013868.571,572.27-703.70-5,098.85
20141,326.993,194.92-1,867.93-6,966.77
2015259.70877.47-617.77-7,584.54
3 Replies
MayilVahanan

Hi

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
yadav_anil782
Creator II
Creator II
Author

HI,

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

yadav_anil782
Creator II
Creator II
Author

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])