Discussion Board for collaboration on QlikView Scripting.
i want my 1st week of year instead of january 1st week i want it to be 1st week of april(my starting week of year) and last week March of next year
means 1st week should display april and last week (53/52) shuold be march of next year instead of December.
If you want to show your year like 2010-2011 and also your month should start from Apr,then use above function
YearName(DATE_FIELD,4) AS Year.
It will provide you financial Year format.And all your transaction will be calulated from Apr-to-Mar of selected financial
I hope you are expcting the same.Any clarifications,let me know
you know its not working for weeks its not showing any variation in weeks
means i m cliking on apri its still showing 16th week
thats what i want to change to 1st
It's easiest to to do this with a Master Calendar, but you can do it in a chart expression like:
,-Week(MakeDate(2011,4,1))) // Set the offset to start on April 1
Note that will show "52" -- the last week of the previous year -- due to QV's week rules.
You have to set the year dynamically in the expression.