Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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