topic Re: Help in Emplyee Count. in QlikView

Help in Emplyee Count.

Sun, 24 Mar 2013 12:17:25 GMT

Hi,

I have Year wise Employee details. Now I want to display a chart like this:

I want a Bar graph where the first bar will show the Total No. of Employee till Jun - 2012 and After that all the bar will continuos with increment of Employee.

		2968	2982	3001	-	-	Till This Month Total Employee Count
#. Of Employee	2968	14	30	19	-	-
	Jun-12	Jul-12	Aug-12	Sep-12	-	-	Till Month

Thanks in advance.

Re: Help in Emplyee Count.

Miguel_Angel_Baeyens — Sun, 24 Mar 2013 12:32:58 GMT

Hi,

Using the Interrecord functions and probably RangeSum() will do, as follows:

Sum(NoOfEmployees) + Above(Sum(NoOfEmployees))

Hope that helps.

Miguel

Re: Help in Emplyee Count.

Sun, 24 Mar 2013 12:47:20 GMT

Can u make a expression on below data. Need to Count of Employee till From 1977 to June - 2012 and After that It will increased month by month to till - Mar 2013. But first bar will be the total no. of employee till Jun-2012 and then it will increased till current month.

Thanks.

Re: Help in Emplyee Count.

Sun, 24 Mar 2013 12:47:40 GMT

Thanks.