Bucket Employees based on Tenure

[#1]

Hi,

We are trying to bucket employees based on Tenure in organization, it's dynamic and would be changed on Time selection thus can't put in script. It's being calculated based on Start Date and Termination Date.

Please find attached app, we are not able to select employees in bucketed chart. Please help.

Regards,

Navdeep !

[raajaswin]

May be this will help you

True Dynamic Bucketing in QlikView – Infinity Insight Blog

[#3]

Hey Thanks, we don't want to use macors as I think we can achieve this in front end itself.

[MarcoWedel]

Hi,

one solution could be:

tabEmpTenure:
LOAD * FROM [https://community.qlik.com/servlet/JiveServlet/download/941514-203695/TenureCalculate.xlsx] (ooxml, embedded labels, table is Sheet1);

tabDateLink:
LOAD Id,
     Date([Start Date]+IterNo()-1) as Date
Resident tabEmpTenure
While [Start Date]+IterNo()-1 <= Alt([End date],Today());

tabCalendar:  
LOAD *,  
     Day(Date) as Day,  
     WeekDay(Date) as WeekDay,  
     Week(Date) as Week,  
     WeekName(Date) as WeekName,  
     Month(Date) as Month,  
     MonthName(Date) as MonthName, 
     If(Date=MonthStart(Date),Date) as MonthStart, 
     Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter,  
     QuarterName(Date) as QuarterName,  
     Year(Date) as Year,  
     WeekYear(Date) as WeekYear;    
LOAD Date(MinDate+IterNo()-1) as Date  
While MinDate+IterNo()-1 <= MaxDate;  
LOAD Min(Date) as MinDate,  
     Max(Date) as MaxDate  
Resident tabDateLink;

hope this helps

regards

Marco