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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-10-13 06:46 AM

Calculation of population based on previous months

Hi Al,

There is a problem which I am not able to sort out.

I have to calculate population of any organisation based on different dimensions...

Example is attached herewith:

For example I am explaining the data...

There are region, dept, branch office as main dimensions....

there is joining date , resigning date and transition date...

If a person joins the company then joining date is entered and the respectivve transition date and column count is updated as 1.

I he resigns then resign date is insertd and the transition ate will be the resign date and cnt is updated as -1.

I have calculated the cummulative value.

But I am unable to calculate population in charts, as in data  year2012 on sep 30 there were 309, people and in oct there were only308, but my chart calculates it wrong.

Please suggest..

attrition.qvw
Attrition.qvd
2,229 Views
0 Likes
21 Replies
Anonymous
Not applicable
‎2012-10-15 04:19 AM
Author

Hi Nitin,

  Can you give me correct values according to year,month and day because

I need to check based on your result.

Thanks

SHAIK

669 Views
0 Likes
Not applicable
‎2012-10-15 04:25 AM
Author

In response to Anonymous

PFA

87 KB
669 Views
0 Likes
Anonymous
Not applicable
‎2012-10-15 04:35 AM
Author

Hi,

can you provide correct values for 2012 ,year,Month,Days basis

SHAIK

669 Views
0 Likes
Not applicable
‎2012-10-15 04:44 AM
Author

In response to Anonymous

PFA

At any particular day the value of Cumulative field is the population of the company.

i.e all joins - all resigns previous to that date is the desired value.

Hope you got my point.

663 KB
669 Views
0 Likes
Anonymous
Not applicable
‎2012-10-15 05:14 AM
Author

Hi,

how can i get joins and resign values and Your flag Cnt=1 is selected it showing both working and resigned values.

SHAIK

669 Views
0 Likes
Not applicable
‎2012-10-15 05:26 AM
Author

In response to Anonymous

when cnt is 1 that means a new person has joined and when one resigns the cnt value is -1.

so for particular person there can be two records if he resigns..

please share your id if possible so that i can chat with you and easily explain things.

Its urgent for me that why i am in haste..

Sorry for my rush

669 Views
0 Likes
Anonymous
Not applicable
‎2012-10-15 05:31 AM
Author

call to my number

   08123675239

this is my bangalore number

669 Views
0 Likes
Anonymous
Not applicable
‎2012-10-15 05:41 AM
Author

hi,


Please check tha validation

2012 is  308

2011 is  326

2010 is  317

SHAIK

669 Views
0 Likes
Not applicable
‎2012-10-15 05:55 AM
Author

In response to Anonymous

Yes the value is correct for years

669 Views
0 Likes
johnw
Champion III
Champion III
‎2012-10-15 07:53 PM

In case it's helpful, here's an alternative example of tracking hires, fires and population.

testEmployeeGenderHireFire2.qvw
669 Views
0 Likes