Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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...