topic Re: Sum between dates when month is a dimension in QlikView

Sum between dates when month is a dimension

Marcos_S — Sat, 16 Nov 2024 03:15:58 GMT

Hello, I am not able to solve this challenge: I have a table of people (see attachment) whith Employee ID, Profile, Date In, Date Out, and Number of employees. If we know the employee, we have an ID and the number of employees is 1. If we only know the profile we will need, we do not have an ID and the number of empoyees can be any number.

I need to show a graph per month and per profile, with the number of active employees: so I have to sum the number of employees each month if Date In is before the month and Date Out is after the month.

Any idea?

Many thanks.

Re: Sum between dates when month is a dimension

Sergey_Shuklin — Thu, 20 Jun 2019 06:20:31 GMT

Hello!

Is this solution suitable for you?

Script improving:

LOAD Year, [Employee ID], Profile, [Date In], [Date Out], AddMonths(MonthStart([Date Out]),-1) as rep_date, [Number of employees] FROM People.xlsx (ooxml, embedded labels, table is [Initial table]);

Re: Sum between dates when month is a dimension

Marcos_S — Mon, 01 Jul 2019 09:38:01 GMT

Thanks. I have to test it. I did not realized that I can load the data in a different way in order to show the graph.

Many thanks