topic Re: Logic Required...................!! in QlikView

Logic Required...................!!

aveeeeeee7en — Thu, 16 Apr 2015 05:41:30 GMT

Dear All

Below is the Snapshot of my Requirement:

Also, see the Attachments.

Regards

Av7eN

aveeeeeee7en — Thu, 16 Apr 2015 18:03:42 GMT

Anybody has the Answer for this........???

petter — Thu, 16 Apr 2015 18:36:20 GMT

These expressions should do the trick in your second Chart:

Sum({<CommonYear={$(=max(CommonYear))},CommonMonth={"=$(=Max(CommonMonth))"}>}[Attrition Left])

Sum({<CommonYear={$(=max(CommonYear))},CommonMonth={"<=$(=Max(CommonMonth))"}>}[Attrition Left])

Sum({<CommonYear={$(=max(CommonYear))},CommonMonth={"=$(=Max(CommonMonth))"}>} ClosingMOB)

Sum({1<CommonYear={$(=Max(CommonYear))},CommonMonth={"<=$(=Max(CommonMonth))"}>} ClosingMOB ) / Max(CommonMonth)

((([Cumulative Attrition]/[Avg Closing MOB])*100)/Max(CommonMonth))*12

petter — Thu, 16 Apr 2015 20:45:16 GMT

aveeeeeee7en — Fri, 17 Apr 2015 08:46:08 GMT

Thank You Sir.

It's Logical.

Regards

Av7eN