topic Re: Week numbers in calendar object in App Development

Week numbers in calendar object

Halfar — Tue, 12 Oct 2021 07:06:17 GMT

Hello ,

I am looking for a calendar object with week numbers in it.

can anybody help me with this ?

Re: Week numbers in calendar object

kKoumoundouros — Tue, 12 Oct 2021 08:08:38 GMT

Hello,

Look below URL on how you can generate Master Calendar, in load script is a function that returns the week from given date: Week(InvoiceDate) As Week:

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-Generation-Script/ta-p/1477450

Re: Week numbers in calendar object

Halfar — Tue, 19 Oct 2021 09:13:03 GMT

Thanks you,

But I mean that I need a calendar object with the week numbers in front of the dates

Re: Week numbers in calendar object

kKoumoundouros — Tue, 19 Oct 2021 09:55:02 GMT

Yes sure, use can create a field from two different, for example:

Week(InvoiceDate) & ' ' & InvoiceDate as Date