Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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) )
How you get Month, Year, and Day fields let me know.
Makedate(Year, Month, Day) as DateField
?
Then use
Week( DateField)
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) )
The Month, Day, and Year fields comes from an MPWR file (time tracking system).
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.