topic Date formatting in QlikView

Date formatting

Mon, 12 Dec 2011 15:30:42 GMT

Hello !

I think I remember that QlikView can formatting the date when we insert it from an excel file.

I have my date DD/MM/YYYY and I want to sort my data by day, month , year and week.

I know that for example if I want to sort by month I can write "date(monthstart(DATE),'MM/YYYY')"

But is it possible to count weeks (from 1 to 52) ?

Please help me ...

Annie

Date formatting

swuehl — Mon, 12 Dec 2011 16:03:04 GMT

Annie,

I think there is no format code for week number, but you could try this:

=dual(WeekYear(Date) & ' / W' & week(Date) ,Weekstart(Date))

Hope this helps,

Stefan

Date formatting

Mon, 12 Dec 2011 16:46:45 GMT

Thank you it works !

I have a last question...

Actually I have my months like this : 01/2007 02/2007 ... 01/2008 02/2008

If I write this : "date(monthstart(Date),'MM/YYYY')", months are duplicate for the year.

Can I have only a list of month from 1 to 12 and clik on the year to have the right month.

Date formatting

swuehl — Mon, 12 Dec 2011 17:12:29 GMT

Yes, use month(Date) to retrieve these values.

Month() will also return a dual, so I think you will get something like 'Dec' if you type in =month(today()) in a text box, but '12' if you use a num() around: num(month(today())) or num(month(Date)))

Regards,

Stefan

Date formatting

Tue, 13 Dec 2011 08:36:27 GMT

Thank you