Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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