Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

maxsheva
Contributor

Generate in script unique numbers for date field with sort

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.

1 Solution

Accepted Solutions

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

You can try

Data:

Load Field1, Field2, Date From TableName;

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

3 Replies

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

May be

AutoNumber(Date) as Num

maxsheva
Contributor

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

I already tried it but sort is not ascending by date

1.jpg

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

You can try

Data:

Load Field1, Field2, Date From TableName;

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

Community Browser