Year Month Autonumber should be incremental order

[rajeshqvd]

Hello All,

Required below  output in qlik script

this is coming for autonumber :

Required Output:

2019 Jan	1
2019 Feb	2
2019 Mar	3
2019 Apr	4
2019 May	5
2019 Jun	6
2019 Jul	7
2019 Aug	8
2019 Sep	9
2019 Oct	10
2019 Nov	11
2019 Dec	12
2020 Jan	13
2020 Feb	14
2020 Mar	15
2020 Apr	16
2020 May	17
2020 Jun	18
2020 Jul	19
2020 Aug	20
2020 Sep	21
2020 Oct	22
2020 Nov	23
2020 Dec	24

Note : don't use sort order and rec no().

Thanks

[tresB · Accepted solution]

Try like: 

Table1:
Load
       YM,
       Date#(YM, 'YYYY MMM') as [YM Num]
From <>;
Tab2:
Load
      Autonumber(YM) as [YM Seq],
      YM
Resident Table1 Order By [YM Num];

[Vegar]

Autonumber is numbering your YM in order of firat appearance. If the first apperance in your data is 'November 2019' then it will be classed as 1. To ensure the desired autonumber order you need to control the order of first appearance for the field values in your data model.

This could be ensured I multiple ways, but most common would be using an order by or generate the dimension using a controlled script loop.