topic Re: Generate in script unique numbers for date field with sort in QlikView

Generate in script unique numbers for date field with sort

maxsheva — Wed, 05 Apr 2017 08:16:25 GMT

Hi,

I need generate in script unique numbers for date field with sort by ascending.

Date

01/01/17

01/02/17

01/03/17

02/2017

02/15/17

I need

Num, Date

1, 01/01/17

2, 01/02/17

3, 01/03/17

4, 02/15/17

5, 02/2017

Thx.

MK_QSL — Wed, 05 Apr 2017 08:24:51 GMT

May be

AutoNumber(Date) as Num

maxsheva — Wed, 05 Apr 2017 08:37:43 GMT

I already tried it but sort is not ascending by date

MK_QSL — Wed, 05 Apr 2017 08:39:17 GMT

You can try

Data:

Load Field1, Field2, Date From TableName;

Left Join (Date)
Load Date, AutoNumber(Date) as Num Resident Data Order By Date;