Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
garyvary123
Contributor III
Contributor III

Variable Slider

Hi guys, quick question about using variable sliders in Qlik Sense.

I have a data set with data from Monday to Friday by date for the year of 2021. I currently have a slider with min(Date) and max(Date) as the range but this includes Saturdays and Sundays.

Is there a way to remove the Saturdays and Sundays from my slider? Thank you!

2 Replies
anat
Master
Master

Not match( weekday(date field), 'sat', 'sun'), date field) 

mikaelsc
Specialist
Specialist

max({<Weekday={0,1,2,3,4}>}Date)

create weekday in the script... https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...