topic Re: Week in QlikView

Week

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have one column data like ....

Day

01 mar

02mar

03 mar

04mar

05 mar

06 mar

07 mar

08 mar

09 mar

10 mar

11 mar

12 mar

13 mar

14 mar

15 mar

16 mar...........................

Here i need week numbers.

Re: Week

oknotsen — Mon, 28 Mar 2016 15:11:19 GMT

Convert the data to actual dates. Once done, use the week() function to generate an extra field that contains the week number.

To convert to date, use the date#() function.

Re: Week

MarcoWedel — Mon, 28 Mar 2016 23:01:20 GMT

‌and what about the year?

Re: Week

Tue, 29 Mar 2016 04:49:43 GMT

Hi Marco Wedel,

In my data year is not there.

Re: Week

amit_saini — Tue, 29 Mar 2016 05:07:11 GMT

Hi,

Once you are having DATE field in Data model , simply write script below to get Month, Week , Year out of it.

LOAD

DATE,

Year(DATE) as YEAR,

Month(DATE) as MONTH,

Week(DATE) as WEEK,

WeekDay(DATE) as WEEKDAY,

Day(DATE) as DAY,

From

.....

Thanks,

Re: Week

Tue, 29 Mar 2016 05:19:58 GMT

Hi AS,

I don't have DATE field . I have only Day field

Re: Week

Chanty4u — Tue, 29 Mar 2016 05:22:41 GMT

chk dis

Week creation

Redefining the Week Numbers

Re: Week

tyagishaila — Tue, 29 Mar 2016 05:36:23 GMT

Try it,

Test:

Load *,

Left(Day,2) as D,

right(Day,3) as M,

year(Today()) as Y

Inline [

Day

01 mar

02mar

03 mar

04mar

05 mar

06 mar

07 mar

08 mar

09 mar

10 mar

11 mar

12 mar

13 mar

14 mar

15 mar

];

Load *,

Makedate(Y, Month(Date#(M, 'MMM')), D) as Date1

Resident Test;

Drop Table Test;

in Expression: Week(Date1)

Re: Week

tyagishaila — Tue, 29 Mar 2016 05:52:51 GMT

Or by using this You can make script more simple,

Test:

Load *,

Makedate(year(Today()), Month(Date#(right(Day,3), 'MMM')), Left(Day,2)) as Date1

Inline [

Day

01 mar

02mar

03 mar

04mar

05 mar

06 mar

07 mar

08 mar

09 mar

10 mar

11 mar

12 mar

13 mar

14 mar

15 mar

];

Cheers

Re: Week

agustinbobba — Tue, 29 Mar 2016 18:33:03 GMT

Try this!

Days:
LOAD * INLINE [
    Day
    3/1/2015
    3/2/2015
    3/3/2015
    3/4/2015
    3/5/2015
    3/6/2015
    3/7/2015
    3/8/2015
    3/9/2015
    3/10/2015
    3/11/2015
];


Weeks:
LOAD 
  Week(Day) AS Week,
  WeekName(Day) AS WeekName
Resident Days;

Re: Week

MarcoWedel — Tue, 29 Mar 2016 22:55:53 GMT

If you do not have the year information within your data then please specify the week number definition you want to use in this case to get unambiguous results.

Iso-weeks e.g. vary for the same day/month within different years:

hope this helps

regards

Marco

Re: Week

Wed, 30 Mar 2016 06:28:21 GMT

Thanks all to sharing information,

finally I got output

Re: Week

tyagishaila — Wed, 30 Mar 2016 07:25:28 GMT

Its good,

share solution with us.

for which year you get weeks?

Re: Week

Wed, 30 Mar 2016 07:54:49 GMT

Hi tyagishaila,

i tried like this

week(DATE(DATE#(fieldname,'DD MMM'),'MM/DD'))

Re: Week

MarcoWedel — Wed, 30 Mar 2016 08:11:12 GMT

Please close your thread by selecting a correct answer

Thanks

Regards

Marco

Re: Week

tyagishaila — Wed, 30 Mar 2016 11:27:50 GMT

Well Done.

but as you have some Day's values are like

02mar

04mar

means not follow 'DD MMM' format.. those values will be missed.

Hi Experts,

I have one column data like ....

Day

01 mar

02mar

03 mar

04mar

05 mar

06 mar

07 mar

08 mar

09 mar

10 mar

11 mar

12 mar

13 mar

14 mar

15 mar

16 mar......

or it type by mistake. I considered that your Day field is string without any common format.

Re: Week

Wed, 30 Mar 2016 12:13:26 GMT

Hi tyagishaila,

I have data format in column like 'DD MMM' only.

Thanks,