Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using LastWorkdate with negative increments

Hi all,

I am trying to make Lastworkdate work with negative increments but it does not work.Does anyone had the same problem and can shed a light on this?

For example: Take a date (22/03/2016), subtract 10 day and you get 12/03/2016. After that you apply Lastworkdate function with 1 as a parameter (Lastworkdate(12/03/2016,1) and get 14/03/2016, Monday. That's ok so far.

Now take another date (23/03/2016) and do the same calculation. The result will be the same again, as above. My problem is in here:

I want user to move a selected date either to the front or behind and with that all the subsequent dates to move together.

There's an example below to illustrate better what I would like to do.

Original DateMovement (forward or backward)Date Modified
22/03/2016-1014/03/2016
23/03/2016-1015/03/2016
24/03/2016-1016/03/2016

Thanks in advance.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Problem solved. I used FirstWorkDate.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Problem solved. I used FirstWorkDate.