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
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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: 
Not applicable
‎2013-06-23 07:41 PM

Last 5 working days of each month

I have got a date(as_of_date)  field in a table (sales) containing sale dates from sept 2012 to June 2013.  days we had no sale were not recorded and as such  as_of_date field ONLY contains dates when a sale was made.  I  would like to get last 5 working days of each month (when sales was made)  in a dropdown starting from June 2013 going back to Sept 2013.

Any help is appreciated. 

342 Views
0 Likes
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2013-06-24 04:14 AM

Try if(networkdays(as_of_date,as_of_date) and as_of_date>=firstworkdate(monthend(as_of_date),5),as_of_date) as Last5WorkDaysOfMonth


talk is cheap, supply exceeds demand
225 Views
0 Likes