Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

shivani_singhal
New Contributor II

header count trend

How can I make deptt-wise month-wise trend(header count trend)?

I have linked the Master Calendar with the following scripting. Please suggest me a way to generate the deptt-wise month-wise trend.

SCRIPTING:

fact:

load * inline [

EmpID,WefDate,Dept

1,15/07/2016,HR

1,01/01/2017,Admin

2,25/09/2016,HR

3,25/09/2016,Analytics Developer

3,01/02/2017,Analytics Sales

4,01/08/2016,Analytics Sales];

details:

load*,

DATE(DOJ)&' - '&date(DOL) as Period;

load * Inline [

EmpID,DOJ,DOL

1,15/07/2016,

2,25/09/2016,31/12/2016

3,25/09/2016,

4,01/08/2016,

];

Bridge:

inner join IntervalMatch("WefDate",EmpID)

Load distinct

DOJ,

DOL,EmpID Resident details;

DROP TABLE details;