topic Re: Converting WeekNo to Date format in QlikView

Converting WeekNo to Date format

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

Hi,

I want to convert my Weekno to date format.

Weekno

And i also want to find starting date of the week.

Regards,

Joshua.

tamilarasu — Sat, 18 Jun 2016 04:46:45 GMT

Hi joshua,

Try MakeWeekDate() function. Syntax should be

MakeWeekDate(Year, Week)

Load Script:

Load *,

MakeWeekaDate(YearField,WeekField)

From source;

Expression:

=MakeWeekDate(2016, 24)

ajsjoshua — Sat, 18 Jun 2016 05:05:03 GMT

Hi Sago,

Its working bro

=MakeWeekDate(Year, Week)

how to calculate the day start of this.

Regards,

Joshua.

tamilarasu — Sat, 18 Jun 2016 05:07:43 GMT

By default, the MakeWeekDate function shows monday as start of the week.

ajsjoshua — Sat, 18 Jun 2016 05:14:51 GMT

Nandri sago Its working fine.

tamilarasu — Sat, 18 Jun 2016 05:20:49 GMT

Welcome bro.