how to get month field by using week field - Qlik Community

Report Inappropriate Content · ‎2013-03-14

can anyone help me in creating month field by using the week field

MayilVahanan · ‎2013-03-14

HI

refer

if you have year n week field

Hope it helps

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

Report Inappropriate Content · ‎2013-03-14

Hi appache77,

What is the format number of your week field? Is it an integer, a date? share you app and data.

Regards,

Ricardo

Report Inappropriate Content · ‎2013-03-14

my format is of week is

01

02

03

04

05

.............

Anonymous · ‎2013-03-14

Do you have year field? If not, there is no relaible way, because the same week# can be in the different months depending on year.

And, what is your rule for the weeks that overlap months?

Regards,

Michael

Report Inappropriate Content · ‎2013-03-14

I am having year field and week field from this i need month

Report Inappropriate Content · ‎2013-03-15

Can you upload your sample application

jagan · ‎2013-03-15

Hi,

Try this

=Month(MakeWeekDate(YearFieldName, WeekFieldName) )

Hope this helps you.

Regards,

Jagan.

Anonymous · ‎2013-03-15

See function MakeWeekDate. Assuming you don't have day, by default it is Monday:

month(MakeWeekDate(Year, Week))