

Creator
2017-08-09
05:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlikview expression based on last 30 working days
Hello
I'm trying to figure out how to build an expression which does a count of an ID for the past 30 working days. I created a WeekEnd flag but I'm not getting the results I expect:
count(distinct(if(Date >= Today()-30 AND WeekEndFlag = 0,ID)))
I believe this is just omitting weekends in the past 30 days. How can I get the past 30 working days (Mon- Fri)?
515 Views
3 Replies

Anonymous
Not applicable
2017-08-09
06:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
=count(distinct {<Date={'>=$(=today()-30)'},WeekEndFlag={'0'}>} ID)
429 Views

Master III
2017-08-09
06:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andrew,
=NetWorkDays(Date(Today()-30),Today())
Regards,
Antonio
429 Views


Master III
2017-08-10
09:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Date(FirstWorkDate(Today(),30),'YYYY-MM-DD')
hth
Sasi
429 Views
