topic Re: autogenerate in QlikView

autogenerate

Mon, 20 Apr 2015 15:12:13 GMT

Hi All,

Can you pse assist. I have a date column with each date being received several times. I would like to create a distinct list of these dates, which I can do, but more importantly generate a number for each unique date (in sequence from 1-1 being the oldest date etc). Assuming the field name is Date, can anyone assist.

Thanks

Herbert

Re: autogenerate

Anonymous — Mon, 20 Apr 2015 15:18:59 GMT

Try this,

dt:

Load

Distinct

;

LOAD * INLINE [

1/1/2015

2/1/2015

3/1/2015

];

dt2:

NoConcatenate

Load

dt,

rowno() as seqno

Resident dt

order by

dt desc

;

drop table dt;

Re: autogenerate

ramoncova06 — Mon, 20 Apr 2015 15:19:29 GMT

what you want is a master calendar, read this post The Master Calendar

Re: autogenerate

Tue, 21 Apr 2015 16:05:34 GMT

Hi There,

No, I am not looking for a master calendar.

I have a list of dates, which I need them loaded as they are, and I want to assign an autogenerate number to each of these dates as these dates represent sale days

Thanls