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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?