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: 
cristianj23a
Partner - Creator III
Partner - Creator III

Restart week count for labor.

Hello, Chic @ s

I'm trying to get the number of weeks based on the LABOR.

Objective:

Get N ° Weeks per person based on LABOR.

Logic:

Each person starts a LABOR on a certain date, the count of the week begins (Monday to Sunday is a week).

When that LABOR ends, restart the week count with another LABOR.

Example:

A "SEMANA" field was added in the Excel to make an example of how it should appear in Qlikview.

The "N ° PERSONAL = 3397" is you have several LABOR from May to July.

As it is displayed in the week field, the countdown is restarted every 7 days (it is counted from Monday to Sunday).

Captura.PNG

If we filter the "LABOR = 'PODA DE PRODUCCIÓN'", we realize that the count is restarted, until "WEEK = 5", because it only performs that LABOR.

Captura.PNG

Captura.PNG

please help me get the amount of the week according to the work, date and staff.

Greetings.

I attach the excel.

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
0 Replies