Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Alternative for WeekEnd function ?

Hi All

I am using a WeekEnd function in my load script to get a master calender at week level and the result I am getting is the date converted with respective weekend dates with the time stamp. I want the output without the time-stamp. I have tried converting the output format by using date and left function but they dont seem to work.

All the three examples below :

1. Weekend(Date_Example,0,5)

2. Date(floor(Weekend(Date_Example,0,5)),'MM/DD/YYYY')

3. Left(Weekend(Date_Example,0,5),10)


give same output as '12/2/2016  12:00:00 AM' (with the time stamp) when viewed in excel


is there an alternative for this in qlikview


Thanks,

Monika

10 Replies
Anonymous
Not applicable
Author

It is working now,  I had to use Date(WeekEnd,'MM/DD/YYYY') everywhere

Thanks