Month Start

[nareshthavidishetty]

I have an Month field and it start from Jan to Dec,but i need to show from 2015 Feb to 2016 Jan.

[sunny_talwar]

Try this =YearStart(Today(), 0, 2)

[MK_QSL]

Use below link and create Fiscal Month and Year.

Fiscal Year

[prieper]

You may wish to use the MONTHNAME(MyDate)-function, which delivers fields like Jan-2015, Feb-2015 .....Jan-2016

HTH

Peter

[nareshthavidishetty]

Hi Thank you it works,but from this i need to create an quarter and week starts and the month start from 2015 Feb to 2016 Jan

[sunny_talwar]

May be this

=QuarterName(Today(), 0, 2)

In the script you can create all of these once you are able to specify what is your first month (third parameter above). See the attached screenshot from QlikView Help page: QlikView ‒ quartername - script and chart function, QlikView ‒ weekname - script and chart function

[#7]

For quaters I used the following:

in SQL

right(convert(char(4),YEAR(TradeDate)),4) +' Q' + convert(char(1),datepart(qq, TradeDate)) as Quarter

hope this helps.

[Anonymous]

Goto Script -> Main Tab -> List of Default Variable...

Change this pattern

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

to

SET MonthNames='Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan';

[nareshthavidishetty]

Hi thanks all for your response,I have soled this by using inline which creates a key for month,

Quarter:

Load * INLINE [

Month,Quarter

1,Q4

2,Q1

3,Q1

4,Q1

5,Q2

6,Q2

7,Q2

8,Q3

9,Q3

10,Q3

11,Q4

12,Q4

];