Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an Month field and it start from Jan to Dec,but i need to show from 2015 Feb to 2016 Jan.
Try this =YearStart(Today(), 0, 2)
Use below link and create Fiscal Month and Year.
You may wish to use the MONTHNAME(MyDate)-function, which delivers fields like Jan-2015, Feb-2015 .....Jan-2016
HTH
Peter
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
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
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.
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';
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
];