Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help in Emplyee Count.

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.

296829823001--Till This Month Total Employee Count
#. Of Employee2968143019--
Jun-12Jul-12Aug-12Sep-12--Till Month

Thanks in advance.

3 Replies
Miguel_Angel_Baeyens

Hi,

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

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

Hope that helps.

Miguel

Not applicable
Author

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.

Not applicable
Author

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.