Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

want to change 1st week from January to April.

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.

8 Replies
Not applicable
Author

Hi,

  Do you want show your Years interms of Finanacial Year?If it so you can use YearName(field_name,4).

Any clarifications,let me know

-Jai

Not applicable
Author

can you please clearly explain it ;

Not applicable
Author

what i want is if i ll click on april it ll show me 1 in week

Not applicable
Author

Hi,

      If you want to show your year like 2010-2011 and also your month should start from Apr,then use above function

Ex:

  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

year.

I hope you are expcting the same.Any clarifications,let me know

-Jai

Not applicable
Author

no its not working its showing year by adding 4 i don know y

my years are 2010 and 2009 and its showing 2013 and 2014 

Not applicable
Author

HI,

  It should be a  YearName(DATE_FIELD,0,4) AS Year.

I have attached a sample exp..Any clarifications,let me know

-Jai

Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It's easiest to to do this with a Master Calendar, but you can do it in a chart expression like:

=week(

          weekStart(MakeDate(2011,4,1)

          ,-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.

-Rob