Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lon7789
Contributor
Contributor

Using Pick () function for weekdays

I am trying to get data from Saturday through Monday for Tuesdays. But the below code doesn't seem to work.
It is working fine for other days except Tuesday. 

if(VDate = pick(weekday(today()),
date(today()-3, 'YYYY-MM-DD'),
date(today()-3, 'YYYY-MM-DD') or date(today()-2, 'YYYY-MM-DD') or date(today()-1, 'YYYY-MM-DD'),
date(today()-1, 'YYYY-MM-DD'),
date(today()-1, 'YYYY-MM-DD'),
date(today()-1, 'YYYY-MM-DD'))
, 1, 0) as Ind,

Labels (5)
1 Reply
marcus_sommer

What's the target for your task?