topic AW:Converting a timestamp into a date dimension. in QlikView

Converting a timestamp into a date dimension.

Fri, 25 Sep 2009 22:44:04 GMT

Hi,

I am loading data via a qvd file and have a date field called date which is a timestamp field.

I want a listbox that contains only a single date for each day.

How can I use daystart() or or similar to convert these already loaded date timestamp values into a new field for my date only listbox?

Many Thanks

Sandy

rbecher — Fri, 25 Sep 2009 23:28:32 GMT

Hi Sandy,

a good way is to load a separate date field from the timestamp with function date#(<timestamp>,<date format>) in the same load statement.

Then you can add a date listbox on this field which will display all dates once...

- Ralf

prieper — Fri, 25 Sep 2009 23:29:46 GMT

There are various way, usually we use FLOOR-function for this purpose:

FLOOR(Timestamp)

HTH
Peter

Anonymous — Sat, 26 Sep 2009 05:48:35 GMT

I always use date(floor(field))

Sat, 26 Sep 2009 15:42:35 GMT

Thanks for all the useful suggestions.

I have used date(floor(date)) and it works fine!

Cheers

Sandy