# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor III

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

Dear All

Below is the Snapshot of my Requirement:

Also, see the Attachments.

Regards

Av7eN

Tags (1)
1 Solution

Accepted Solutions
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
Valued Contributor III

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

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

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

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

Valued Contributor III

Thank You Sir.

It's Logical.

Regards

Av7eN