topic Re: Alternative for WeekEnd function ? in App Development

Alternative for WeekEnd function ?

Anonymous — Fri, 17 Nov 2017 10:26:31 GMT

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

Re: Alternative for WeekEnd function ?

sunny_talwar — Fri, 17 Nov 2017 12:55:15 GMT

Which object are you exporting this from?

Re: Alternative for WeekEnd function ?

Anonymous — Fri, 17 Nov 2017 13:07:22 GMT

Default table in Qlik Sense.

Re: Alternative for WeekEnd function ?

sunny_talwar — Fri, 17 Nov 2017 13:09:48 GMT

I thought you were using QlikView because all your tags mentioned QlikView

Not sure why it exports with the time portion, but may be add date as Date(WeekEnd, 'MM/DD/YYYY') in your table.

Re: Alternative for WeekEnd function ?

Anonymous — Fri, 17 Nov 2017 13:16:22 GMT

My thought process was back end load scripts for qlikview and qliksense are essentially the same.

At least it works for my version of Qlik Sense.

Still gives the same output with time stamp

Re: Alternative for WeekEnd function ?

sunny_talwar — Fri, 17 Nov 2017 13:18:18 GMT

Do you have another date field which doesn't have the same problem? I guess what I am getting at is that may be this more an issue of how the export works and how Excel handles it versus how you define it in the script/

Re: Alternative for WeekEnd function ?

Anonymous — Fri, 17 Nov 2017 13:25:54 GMT

yes the normal week end dates in the raw data file, they are exported without the time stamp. But excel is showing the WeekEnd dates with time stamp. Also when I join on these weeks my metric values are zero. Since the format of these two weeks are different

Re: Alternative for WeekEnd function ?

sunny_talwar — Fri, 17 Nov 2017 13:28:33 GMT

Join in the script? Join in the script don't look at the format... as long as the underlying numeric value is the same... just to confirm, you are using this, right?

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

Re: Alternative for WeekEnd function ?

Anonymous — Fri, 17 Nov 2017 13:31:51 GMT

Yes

Re: Alternative for WeekEnd function ?

sunny_talwar — Fri, 17 Nov 2017 13:33:22 GMT

Then I don't see why script joins would cause an issue... can you share a sample?

Re: Alternative for WeekEnd function ?

Anonymous — Fri, 17 Nov 2017 13:55:24 GMT

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

Thanks