Date number

Anonymous — Thu, 11 Aug 2016 21:34:55 GMT

Hi guys,

I have a file with a list of dates

Load

PIN

Application_Medium

Application_date

FROM

(ooxml, embedded labels, table is [Results]);

Is there an autonumber function i can use to assign a sequential number to each date starting from lowest to highest? So for example

Date	Date #
01/01/2016	1
01/02/2016	2
01/03/2016	3
01/04/2016	4

Re: Date number

sunny_talwar — Thu, 11 Aug 2016 21:36:31 GMT

Sure, you can try

AutoNumber(Application_date) as Date#

but you will have to make sure that the table is sorted in the ascending order of Application_date to give the correct sort order. Sorting (using Order By) can only be done in Resident load.

Something along these lines:

Table:

LOAD PIN

Application_Medium

Application_date

FROM

(ooxml, embedded labels, table is [Results]);

FinalTable:

LOAD *,

AutoNumber(Application_date) as Date#

Resident Table

Order By Application_date;

DROP Table Table;

topic Re: Date number in QlikView

Date number

Re: Date number