Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anselmo_meira
Contributor II

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
Highlighted
anselmo_meira
Contributor II

Re: Using LastWorkdate with negative increments

Problem solved. I used FirstWorkDate.

View solution in original post

1 Reply
Highlighted
anselmo_meira
Contributor II

Re: Using LastWorkdate with negative increments

Problem solved. I used FirstWorkDate.

View solution in original post