topic Re: Extract year from year in QlikView

Extract year from year

Fri, 11 Apr 2014 08:32:24 GMT

hi All,

I have a requirement, where in i should show week number extracting from year field.

In detail, week(year) should have list of 52 or 53 weeks of that particular year.

If i select, 2014, feb, week should display 5,6,7.

Quick response is appreciated.

Thanks in advance,

Smitha

its_anandrjs — Fri, 11 Apr 2014 08:36:48 GMT

From this you get week

Week(YourDateField) as Week

Correct way is use Datefield for the different date field creation like

Year(YourDateField) as Year,

Month(YourDateField) as Month,

Week(YourDateField) as Week

Num(Month(YourDateField)) as NumMonth,

'Q' & ceil(month(YourDateField) / 3) as Quarter

and so on

MK_QSL — Fri, 11 Apr 2014 08:38:44 GMT

Add below in your script...

Week(DateField) as Week

rustyfishbones — Fri, 11 Apr 2014 08:41:37 GMT

Try

Week(Date) as Week

Fri, 11 Apr 2014 08:44:38 GMT

Thank you ☺

Fri, 11 Apr 2014 08:44:38 GMT

thanks☺

Fri, 11 Apr 2014 08:44:39 GMT

Thanks☺

MK_QSL — Fri, 11 Apr 2014 08:45:35 GMT

Close the thread by selecting correct/helpful answer.

its_anandrjs — Fri, 11 Apr 2014 09:02:48 GMT

Hi,

If you got correct answer so mark the thread as correct for the reference for others.

Regards