Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
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



10 Replies
Not applicable

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