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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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
MVP
MVP

What's the target for your task?