Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
smilingjohn
Contributor III

Date

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

3 Replies
andrey_krylov
Valued Contributor

Re: Date

Like this?

shalininavo
New Contributor II

Re: Date

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
New Contributor III

Re: Date

Is it like this?