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
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

 

953 Views
0 Likes
1 Solution

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

948 Views
2 Replies
rwunderlich
MVP
MVP
‎2022-04-12 12:20 PM

=LastWorkDate(MyDate, 5) 

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

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

Thanks

918 Views
0 Likes