Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create week field by using monthyear field

i am having a field monthyear which shows 201302   yearmonth

by using this field i have to create week numbers

can anyone help me

2 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

=Week(MakeDate(Left(YearMonth), Right(2)))

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

it is not working

i am using this

WeekName([ Date], 0, -1) as Week,

by this i am getting the week numbers and year but i need only week numbers year should not be shown