topic Re: Calculating the head count base on the selection in QlikView

Calculating the head count base on the selection

nizamsha — Tue, 01 Jul 2014 05:42:15 GMT

Hi All,

I Am Facing the Issue for calculating the headcount based on the selection .Here by attached the sample xls .please provide solution me

Re: Calculating the head count base on the selection

Tue, 01 Jul 2014 05:51:33 GMT

If you didn't specify any condition by default it will give value according to current selection only.

try count(ID). this will give you the value for your current selection.

Re: Calculating the head count base on the selection

nizamsha — Tue, 01 Jul 2014 05:55:40 GMT

Hi All

For calculating the head this what i done and this what is in excel

3 column i have

Let vStartDate=MakeDate(2014,1);

Let VMinDate=MonthEnd(Today());

EMPID,

DOJ,

Termination,

For startdate i have a condition like this if(DOJ< vStartDate,vStartDate,DOJ) as StartDate

for EndDate i Have Comdition like this if(len(Term Date)=0, vEndDate,Term Date) as EndDate

for end date i dont want to take to an consideration who got terminate before the start year i only want to check active ones

after getting the startdate and enddate i want to generate a random month between startdate and enddate for the employee and also create a status 1 if he is active if he is not active mean 0

Re: Calculating the head count base on the selection

vikasmahajan — Fri, 16 Jan 2015 10:06:47 GMT

Did you got solution??????????

Vikas