Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitinmbd
Partner - Contributor III
Partner - Contributor III

Opening and Closing Calculation

Dear All,

I am presently working on the opening and closing logic for attrition calcuation and i am stuck.

i have implemented the logic in the attached file. the logic is working fine for month on month

but when i put any dimension in the chart and select multiple months then it gives me the wrong calculation

for attrition.

Attrition formula = (No of resignies in the Selected month)/((Closing for MaxMonth+Opening for Minimum Month)/2)

Please refer the attach qvw file for detail.

10 Replies
vikasmahajan

Can u give solution for my thread Cummulative Graph

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.