topic How to assign value(ID) to CalendarDate? in QlikView

How to assign value(ID) to CalendarDate?

Wed, 29 Feb 2012 15:49:10 GMT

hi everybody,

how I can assign a value(Id) to a CalendarDate, like:

I have:

storeid | calendardate | Id

123 | 22.01.2012 | 2

123 | 23.01.2012 | 1

123 | 26.01.2012 | 5

123 | 01.02.2012 | 3

123 | 07.02.2012 | 4

I need:

storeid | calendardate | Id

123 | 22.01.2012 | 1

123 | 23.01.2012 | 2

123 | 26.01.2012 | 3

123 | 01.02.2012 | 4

123 | 07.02.2012 | 5

Thx in advance.

How to assign value(ID) to CalendarDate?

rajeshvaswani77 — Wed, 29 Feb 2012 15:53:03 GMT

You can use RecNo() function to generate numbers from 1 onwards.

How to assign value(ID) to CalendarDate?

Wed, 29 Feb 2012 16:04:10 GMT

RecNo() function will doesn't work because I have group my Id to the StoreID:

My Table look like this::

storeid | calendardate | Id

123 | 22.01.2012 | 2

123 | 23.01.2012 | 1

123 | 26.01.2012 | 5

123 | 01.02.2012 | 3

123 | 07.02.2012 | 4

456 | 28.01.2012 | 2

456 | 30.01.2012 | 1

789 | 24.01.2012 | 2

789 | 28.02.2012 | 3

789 | 01.03.2012 | 1

I want for Id the same order as calendardate.

How to assign value(ID) to CalendarDate?

rajeshvaswani77 — Wed, 29 Feb 2012 16:09:38 GMT

Convert the date in to the real date. sort by the date then and use recno() to generate your row.

How to assign value(ID) to CalendarDate?

Anonymous — Wed, 29 Feb 2012 16:14:39 GMT

mmmm load the calendardate 2 times like this

load

calendardate,

calendardate as ID,

....

and when use ID change the format number for Integer.

Maybe help you

How to assign value(ID) to CalendarDate?

Wed, 29 Feb 2012 17:23:08 GMT

the calendardate is already in the right order, I want the same order for Id.

How to assign value(ID) to CalendarDate?

rwunderlich — Wed, 29 Feb 2012 20:06:19 GMT

autonumber(calendardate, storeid) as Id

-Rob

How to assign value(ID) to CalendarDate?

CELAMBARASAN — Thu, 01 Mar 2012 06:32:39 GMT

Hi,

Have you tried with the RowNo() function?

Celambarasan