Discussion Board for collaboration related to QlikView App Development.
I want calculate percentage based on range of unitno's that are associated with contract number.
I have attached my sample excel file and QVW which will explain more better about my concern.
I used dummy data here and i am getting actual data from db.
Please have a look and help me.
Thanks & Regards,
Thanks for reply.
I am expecting the result as shown in attached excel.
and one more point is i am showing unit no in report. but result should be displayed based on associated units for a contract.
I have month-year dimension also in my report, so contract no's will be repeated for month-&year
Please refer attached excel. I need result(%CoEst) as shown in attached excel. I explained logic in Column F.
Please have a look and let me know your ideas.