Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date display


Hi

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

6 Replies
rustyfishbones
Master II
Master II

Try this

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

hic
Former Employee
Former Employee

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

HIC

Not applicable
Author

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

Not applicable
Author

Hi Alan

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

Regards

Fanie

MayilVahanan

Hi

Try like this too..

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Ashutosh

Works like a charm.

Great  - thank you.

Fanie