Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to exclude sat and Sun in date field?

Hi

I Have date filed like DD/MM/YYYY

now i want to show date filed list box that excluding Sat and Sun

please help

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

2 Replies
neelamsaroha157
Specialist II
Specialist II

Try this

if(not Match(WeekDay(Date),'sun','sat'), Date) as DateWithoutSatSun

neelamsaroha157
Specialist II
Specialist II

Attached sample