Discussion board where members can get started with QlikView.
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
date(Created,'DD/MM/YYYY') as Created,
Week(Created) as Week,
(ooxml, embedded labels, table is Sheet1);
date(WeekEnd(Created),'DD/MM/YYYY') as WeekEndDate,
date(Weekstart(Created),'DD/MM/YYYY') as WeekstartDate
drop Table Test "
Is it like this?