Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruthie09
Contributor III
Contributor III

How to chart business days only

I'm sure this is completely simple but here goes:  How do I chart only business days?

Right now, my expression is   =Date([IncCreated.autoCalendar.Date],'MM/DD/YY')  but I do not want to include weekends.  How do I do that?

Thanks!

Labels (4)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

With your expression, you could use:

=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')

But it would more useful if you created a flag in your load script.  You would use the similar if statement logic in your load script.

 

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

With your expression, you could use:

=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')

But it would more useful if you created a flag in your load script.  You would use the similar if statement logic in your load script.

 

View solution in original post

Ruthie09
Contributor III
Contributor III
Author

PERFECT!!!  Both ideas are excellent!  Thank you Gary!!!!!!!!!!!!!!!!