topic Re: Adding Monthly accruals in QlikView

Adding Monthly accruals

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I would like a field to accumulate/accrue days of 1.67 per month.

Eg. if an employee has 0 days leave, he would accumulate 1.67 days per leave which should accrue each month.

What script would be best in achieving this?

shiveshsingh — Tue, 22 May 2018 13:12:34 GMT

Can you elaborate your requirement? Not able to get it.

marcelviegas — Tue, 22 May 2018 13:16:16 GMT

Can you elaborate your requirement? Not able to get it.

Anonymous — Tue, 22 May 2018 13:38:58 GMT

If I am an employee with 0 days leave, each month 1.67 days of leave will be added to my Leave Balance.

In order for this to continue adding 1.67 days of leave, I'm not sure what the script should look like?

EG.

marcelviegas — Tue, 22 May 2018 17:52:26 GMT

how is your source table or script?
Does he get the month or you should get the months automatic?
Do you have how to attach your qvw?

shiveshsingh — Wed, 23 May 2018 07:47:09 GMT

Okay, do you have month column?

Or it needs to be created in inline?

Anonymous — Wed, 23 May 2018 09:48:55 GMT

I do have a Month column that was created with script. Initially it was dates ranging from 01/01/2018 up until 31/12/2018.

Does that help?

marcelviegas — Wed, 23 May 2018 11:13:25 GMT

follows example, if you attach your structure becomes more accurate.

load employee,count(distinct month_table)*1,6

from Table

where month_table <=month(today())

group by employee;

shiveshsingh — Wed, 23 May 2018 11:49:03 GMT

Like this?

Anonymous — Wed, 23 May 2018 11:51:48 GMT

100%! Exactly like that and it sums up each month. Thank you Shivesh

shiveshsingh — Wed, 23 May 2018 11:52:55 GMT

Glad to know it worked

Anonymous — Wed, 23 May 2018 12:10:05 GMT

Thanks Marcel. It's a helpful script