Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mparker123
Contributor

Creating a Week Field

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.

1 Solution

Accepted Solutions

Re: Creating a Week Field

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) )

5 Replies

Re: Creating a Week Field

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

MVP
MVP

Re: Creating a Week Field

Makedate(Year, Month, Day) as DateField

?

Then use

Week( DateField)

Re: Creating a Week Field

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
Contributor

Re: Creating a Week Field

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

mparker123
Contributor

Re: Creating a Week Field

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.