Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.