Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II
‎2022-04-12 11:59 AM

Get the 5th working date from a date field

Hi

How do I get the 

Get the 5th working date from a date field as a measure, not in script.

So if today is 12-04-2022

The result will be 18-04-2022

 

747 Views
0 Likes
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2022-04-12 12:20 PM

=LastWorkDate(MyDate, 5) 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

View solution in original post

742 Views
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2022-04-12 12:20 PM

=LastWorkDate(MyDate, 5) 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

743 Views
D19PAL
Creator II
Creator II
‎2022-04-15 02:08 PM
Author

Thanks

712 Views
0 Likes