Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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
anselmo_meira
Contributor II

Re: Using LastWorkdate with negative increments

Problem solved. I used FirstWorkDate.

View solution in original post

1 Reply
anselmo_meira
Contributor II

Re: Using LastWorkdate with negative increments

Problem solved. I used FirstWorkDate.

View solution in original post