topic Re: Creating a Week Field in QlikView

Creating a Week Field

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

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.

Re: Creating a Week Field

its_anandrjs — Thu, 12 Oct 2017 14:30:53 GMT

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

Re: Creating a Week Field

swuehl — Thu, 12 Oct 2017 14:31:09 GMT

Makedate(Year, Month, Day) as DateField

Then use

Week( DateField)

Re: Creating a Week Field

its_anandrjs — Thu, 12 Oct 2017 14:35:10 GMT

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

Re: Creating a Week Field

mparker123 — Thu, 12 Oct 2017 14:58:23 GMT

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

Re: Creating a Week Field

mparker123 — Thu, 12 Oct 2017 14:59:54 GMT

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.