topic Re: Month Start in QlikView

Month Start

nareshthavidishetty — Thu, 04 Feb 2016 10:47:15 GMT

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

Re: Month Start

sunny_talwar — Thu, 04 Feb 2016 10:51:50 GMT

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

Re: Month Start

MK_QSL — Thu, 04 Feb 2016 10:51:53 GMT

Use below link and create Fiscal Month and Year.

Fiscal Year

Re: Month Start

prieper — Thu, 04 Feb 2016 10:53:37 GMT

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

HTH

Peter

Re: Month Start

nareshthavidishetty — Thu, 04 Feb 2016 11:09:52 GMT

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

Re: Month Start

sunny_talwar — Thu, 04 Feb 2016 11:15:29 GMT

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

Re: Month Start

Thu, 04 Feb 2016 11:32:24 GMT

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.

Re: Month Start

Anonymous — Thu, 04 Feb 2016 11:42:24 GMT

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';

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

Re: Month Start

nareshthavidishetty — Fri, 05 Feb 2016 09:27:00 GMT

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

];