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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get days from weekend?

Hi..

How to get days from weekend?

I used expression as

=Day(WeekEnd(CalendarDate))

But it's not working

2 Replies
Not applicable
Author

try this

WeekDay() function like this


WeekDay(WeekEnd(CalendarDate)) as day2,

or

date(WeekEnd(CalendarDate),'www') as day1,

er_mohit
Master II
Master II

try this one

date(WeekEnd(TempDate),'WWWWW') as CalendarWeekEnd

or

date(WeekEnd(TempDate),'WWW') as CalendarWeekEnd