Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Highlighted
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.

Community Browser