Need a Calender with week and Month

[rishikeshtiwari]

Hi Guys,

I have a table of time sheet. In this table I am getting data in weeks.Example week is 06/September-12/September,13/September-19/September etc.If week is 27/September-03/October then this week will fall under Sep only not Oct.I have a requirement that I need Year ,Month, week and week Number in qlikview.So that I can create a calendar.Year,Month,Weeks should associate with full data set.Fiscal Year started from Apr to Mar (Next Year)

I would request you to help in this logic.

Thanks

Rishi

[marcus_sommer]

You could create a date from your WeekField like this:

date#(subfield(YourWeekField, '-', 1) & '/2015', 'DD/MMMM/YYYY') // year is manually added

     which results in

date#('06/September/2015', 'DD/MMMM/YYYY')

     and which could be use within date-functions like

month(date#('06/September/2015', 'DD/MMMM/YYYY')) or

week(date#('06/September/2015', 'DD/MMMM/YYYY'))

But you need only create the date and the other period-fields would be associated per master-calendar: How to use - Master-Calendar and Date-Values

And would be happens after you transformed your crosstable into a normal table: The Crosstable Load.

- Marcus