Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (2)
6 Replies
rustyfishbones
Honored Contributor II

Re: date display

Try this

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

Employee
Employee

Re: date display

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

HIC

Not applicable

Re: date display

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

Re: date display

Hi Alan

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

Regards

Fanie

Re: date display

Hi

Try like this too..

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

Not applicable

Re: date display

Ashutosh

Works like a charm.

Great  - thank you.

Fanie

Community Browser