topic Re: Date in QlikView

Date

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise

Please find the attachment of qlikview file and excel .

I have created date and other dates

I need to show the week end date and week start date as two separate fields from Created .

Please someone help me on this

Thanks in advance

andrey_krylov — Wed, 10 Oct 2018 07:04:30 GMT

Like this?

Anonymous — Wed, 10 Oct 2018 07:11:51 GMT

Hi,

Try this

"Test:

LOAD Severity,

Status,

date(Created,'DD/MM/YYYY') as Created,

Week(Created) as Week,

Resolved,

Closed

FROM

(ooxml, embedded labels, table is Sheet1);

Load*,

date(WeekEnd(Created),'DD/MM/YYYY') as WeekEndDate,

date(Weekstart(Created),'DD/MM/YYYY') as WeekstartDate

Resident Test;

drop Table Test "

chakiw5 — Wed, 10 Oct 2018 07:13:43 GMT

Is it like this?