topic Re: Week.Year format in QlikView

Week.Year format

Tue, 30 Sep 2014 05:51:41 GMT

hi All,

How we can find weeknumber.YYYY from this date format MM/DD/YYY.

tHANKS

Re: Week.Year format

amit_saini — Tue, 30 Sep 2014 05:53:30 GMT

Try this:

week(Date_Field,'MM/DD/YYY') as weeknumber

Thanks,

Re: Week.Year format

Tue, 30 Sep 2014 05:53:36 GMT

week(date)

Week number. Returns an integer representing the week when the fraction of expr is interpreted as a date according to the standard number interpretation.

Re: Week.Year format

PrashantSangle — Tue, 30 Sep 2014 05:54:50 GMT

Hi,

Write

Week(Date#(Date_Field,'MM/DD/YYY'))

Regards

Re: Week.Year format

amit_saini — Tue, 30 Sep 2014 05:55:58 GMT

Also try this:

week(Datefield) & ' / ' & year(Datefield) as Week,

and for weekday:

weekday(Datefield) as Weekday

Thanks,
AS

Re: Week.Year format

aveeeeeee7en — Tue, 30 Sep 2014 06:03:29 GMT

Use this:

week(YourDateField)&'.'&Year(YourDateField) in your Script and after reload use this field in your Front end.

See the Snapshot:

Also, see the Attachment.

Regards

Av7eN