topic Re: Using Autonumber to generate sequence numbers for two different months in QlikView

Using Autonumber to generate sequence numbers for two different months

Gopi_E — Fri, 15 Nov 2024 23:43:08 GMT

Hi Qliker's,

I hope everyone doing good,

I am facing issue with Autonumber, It's not giving sequence Number,

I want to create Sequence Numbers for two different Months, below one is my code

StartDateMonthNo:
Load StartDateMonth/Year
AutoNumber(StartDateMonth/Year) as StartDateMonthNo
Resident SalesData Order By StartDate Desc;

EndDateMonthNumber:
Load EndDateMonth/Year,
AutoNumber(EndDateMonth/Year) as EndDateMonthNo
Resident HSMS_UK_SERVICE Order By EndDate Desc;

Here i have two different Months(StartDateMonth/Year and EndDateMonth/Year) which is there in SalesData Table,

i need sequence numbers for above two months, but the bove code giving below result.

In Above fields, EndDateMonth/Year having sequence number from 2 to 13 and those numbers are not associate correctly with Month fields,

I need sequence numbers 1 to 12 for each months separately line first Table(StartDateMonth/Year)

Please give any idea for getting sequence numbers,

Thanks In Advance @sunny_talwar and All

Re: Using Autonumber to generate sequence numbers for two different months

Kushal_Chawda — Thu, 29 Oct 2020 11:15:48 GMT

@Gopi_E try below

StartDateMonthNo:
Load StartDateMonth/Year
AutoNumber(StartDateMonth/Year,'Start') as StartDateMonthNo
Resident SalesData Order By StartDate Desc;

EndDateMonthNumber:
Load EndDateMonth/Year,
AutoNumber(EndDateMonth/Year,'End') as EndDateMonthNo
Resident HSMS_UK_SERVICE Order By EndDate Desc;

Re: Using Autonumber to generate sequence numbers for two different months

Gopi_E — Fri, 30 Oct 2020 05:32:56 GMT

Thank you Kush