Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

aveeeeeee7en
Valued Contributor III

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

Dear All

Below is the Snapshot of my Requirement:

Requirement.png

Also, see the Attachments.

Regards

Av7eN

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Logic Required...................!!

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



4 Replies
aveeeeeee7en
Valued Contributor III

Re: Logic Required...................!!

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

MVP
MVP

Re: Logic Required...................!!

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



MVP
MVP

Re: Logic Required...................!!

2015-04-16 #1.PNG

2015-04-16 #2.PNG

2015-04-16 #3.PNG

2015-04-16 #4.PNG

2015-04-16 #5.PNG

aveeeeeee7en
Valued Contributor III

Re: Logic Required...................!!

Thank You Sir.

It's Logical.

Regards

Av7eN

Community Browser