Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
odassier
Creator II
Creator II

Modified AutoCalendar for weekdays only

Hi All,

My data only includes values for Monday-Friday but when using AutoCalendar dates as dimension, and continuous X-axis, Qlik always adds two blank days for the weekends, even though my data does not contain any weekend dates or values.

Can anyone share a .qvf file/template with a modified master calendar for weekdays only ?  All the posts I've seen on this use QlikView and not QlikSense.

Thank you.

 

Olivier

Labels (2)
1 Reply
Or
MVP
MVP

There shouldn't be any difference between QlikView and QlikSense when it comes to the script which generates an auto-calendar, so you can safely use a QV one for QS.

Not sure you can get a continuous axis to ignore weekends, though. That makes it non-continuous... maybe if you make your own "dates" using dual() with underlying values that don't have weekend gaps?