topic Bucket Employees based on Tenure in QlikView

Bucket Employees based on Tenure

Tue, 29 Dec 2015 10:02:21 GMT

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 !

Re: Bucket Employees based on Tenure

raajaswin — Tue, 29 Dec 2015 10:07:23 GMT

May be this will help you

True Dynamic Bucketing in QlikView – Infinity Insight Blog

Re: Bucket Employees based on Tenure

Tue, 29 Dec 2015 10:15:30 GMT

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

Re: Bucket Employees based on Tenure

MarcoWedel — Tue, 29 Dec 2015 22:19:24 GMT

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