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
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

 

719 Views
0 Likes
1 Solution

Accepted Solutions
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

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

Thanks

684 Views
0 Likes