Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.

Tags (1)
8 Replies
Not applicable

want to change 1st week from January to April.

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

want to change 1st week from January to April.

can you please clearly explain it ;

Not applicable

want to change 1st week from January to April.

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

Not applicable

want to change 1st week from January to April.

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

want to change 1st week from January to April.

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

Re: want to change 1st week from January to April.

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

want to change 1st week from January to April.

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
Not applicable

Re: want to change 1st week from January to April.

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