topic Re: date display in QlikView

date display

Wed, 20 Nov 2013 14:32:57 GMT

I need to display YY Week to create a trend spanning many years. I can display

Date(MonthStart([Date Inserted]),'YY MM') as MonthStart, >> as means to display the year and month.

I need the equivalent to display week e.g. 13 42 Year Week No

Please assist.

Fanie

rustyfishbones — Wed, 20 Nov 2013 14:42:04 GMT

Try this

Week(weekstart([Date Inserted]) & '-' & WeekYear([Date Inserted]) ) as YearWeek

hic — Wed, 20 Nov 2013 14:46:18 GMT

Dual(WeekYear([Date Inserted]) & '-W' & Week([Date Inserted]), WeekStart([Date Inserted]))

HIC

Wed, 20 Nov 2013 14:47:25 GMT

Hi,

I think you can concatenate two value for this result.

Year([Date Inserted]) & ' ' & Week([Date Inserted]) as YearWeek

Hope this help you

Regards,

Ashutosh

Wed, 20 Nov 2013 14:50:15 GMT

Hi Alan

Nope - not doing it. But thanks - I'm trying all variations.

Regards

Fanie

MayilVahanan — Wed, 20 Nov 2013 14:50:47 GMT

Try like this too..

Date([Date Inserted] ,'YY') & Week([Date Inserted]) AS YearWeekNo

Wed, 20 Nov 2013 14:56:18 GMT

Ashutosh

Works like a charm.

Great - thank you.

Fanie