Creating a Week Field

[mparker123]

Hello All,

I am wondering how I create a week field in QlikView. I have a Month, Year, and Day field currently; along with a start date and due date field which pertains to projects (prob wouldn't use those to create weeks). Based on those fields how would I create a Date field using those. If anyone as some insight on this I would appreciate it.

Thanks.

[its_anandrjs]

How you get Month, Year, and Day fields let me know.

[swuehl]

Makedate(Year, Month, Day) as DateField

?

Then use

Week( DateField)

[its_anandrjs · Accepted solution]

May be you can go with

Load

Week(Makedate(Year, Month, Day) ) as Week

From Source...

and or calculated dimension if you have Year, Month, Day

=Week(Makedate(Year, Month, Day) )

[mparker123]

The Month, Day, and Year fields comes from an MPWR file (time tracking system).

[mparker123]

I don't mind creating a field in the script using nothing but the script to create it. Meaning not using any fields already and creating a whole new field called Week.