Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Any suggestion how to show cumulative calculation ?
Problem Statement
I am using this formula to calculate average attrition for eachmonth : Count(Exit)/(Count(Active)/Count(Distinct MONTH))
Now i need to show cummulative attrition percenatge for each month i.e. For the month of Feburary attrition will be :
( Total Exit in January and February ) / Average( Headcount in January and February)
Similarly for March :
Total Exit in January ,February & March )/ Average( Headcount in January ,February & March )
Thanks
Anurag Gupta
Anurag,
Is this for Qlik Sense or Qlikview development? Just want to make sure, so we can place you on the proper channels.
Gio
Hi Giuseppe,
I am currently using QlikSense
Thanks
Anurag
Hi Krish,
Can you please help me with Set equation ?
Regards
Anurag
After re-reading your post this may be an easier solution in Sense. This example would be your 'YTD' total Exits and you could use something similar with your average calcs:
rangesum(above(count(Exit),1,RowNo()))+count(Exit)
guptaanu - let us know if you still require assistance on this - there is a very good article here http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums that explains this using QlikView - but you can use these in Sense using expressions with the Load Editor - or within the Master Items to create new measures with these calculations.
If you attach your sample data, we can get a better idea of the structure.
Using rangesum is the correct way to go as Kris Balow mentioned.
I created some sample data (on what I best thought met your need and got this calculation:
sum( aggr( rangesum( above( (sum(Exit)/sum(active)),0,12) ),Month))
I am using SUM because my Exit and Active values are either 1 or 0.
Let us know.
Regards,
Mike
Qlik
Hii
In Qlikview I Want to create view like http://community.qlik.com/message/163026#163026
I am attaching EMP.XLS which as DOJ (Date of join) and DOL (date of leaving) and s_active
for Active/In-Active.
Can you give guide me how to achieve the same in Qlikview.
Vikas