topic Numbering Month list in App Development

Numbering Month list

priyasawant — Tue, 12 May 2020 04:40:48 GMT

Hi,

I have a list of Month so would have to number them from 1,2,3,4 and so as as keeping the Max month as 1

For e.g.

Load Proposal Number,

MonthName

From xyz.qvd

Monthname will have Dec 2019

Jan 2020

Feb 2020

March 2020

April 2020

May 2020

June 2020

July 2020 and so on,

So here Max month i.e. May 2020 will be 1

April 2020 will be 2

March 2020 will be 3

Feb 2020 will be 4

Jan 2020 will be 5

Dec 2019 will be 6

Re: Numbering Month list

tresB — Tue, 12 May 2020 05:21:30 GMT

Sort and number them like:

t1: Load Date(Date#(MonthName, 'MMM YYYY'),'MMM YYYY') as MonthName Inline [ MonthName Dec 2019 Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020]; t2: Load MonthName, RowNo() as MonthNum Resident t1 Order by MonthName Desc; Drop Table t1;

Re: Numbering Month list

Vegar — Tue, 12 May 2020 06:51:53 GMT

See script below

SET vL.FirstMonthOfFiscalYear= 5; [Numbering Month list]: LOAD *, Month(MonthName) as Month, Year(MonthName) as Year, YearName([MonthName],0,$(vL.FirstMonthOfFiscalYear)) as FiscalYear, Dual(Date([MonthName],'MMM'), Num(Month(Monthname([MonthName],-$(vL.FirstMonthOfFiscalYear)+1))) ) as FiscalMonth ; //Below data equvialent to the example in your post Load Monthname(Date) as MonthName, recno() as [Proposal Number] inline [ Date 2020-01-01 2020-01-15 2020-02-01 2020-02-15 2020-03-01 2020-03-15 2020-03-20 2020-04-01 2020-04-15 2020-05-01 2020-05-15 2020-06-01 2020-06-15 2020-06-20 2020-06-30 2020-07-01 2020-07-15 2020-08-01 2020-08-15 2020-09-01 2020-09-15 2020-10-01 2020-10-15 2020-11-01 2020-12-01 2020-12-15 2021-01-01 2021-02-16 2021-02-01 2021-02-15 2021-03-01 2021-03-15 2021-03-20 2021-04-01 2021-04-15 2021-05-01 2021-05-15 2021-06-01 2021-06-15 2021-06-20 2021-07-30 2021-07-01 2021-07-15 2021-07-01 2021-08-15 2021-09-01 2021-09-15 2021-10-01 2021-10-15 2021-11-01 2021-12-01 2021-12-15 ];