topic Create calendar in qliksense in App Development

Create calendar in qliksense

Aspiring_Developer — Tue, 22 Mar 2022 14:55:18 GMT

Hi All,

I have to create a calendar to generate weeks from my date.

The week start should be saturday and weekend should be sunday.

For instance for the month of march :-

5th march - saturday (week start)

6 th march - sunday (weekend)

And we have to follow 52 weeks pattern for the year.

Can anyone please help me , how can i generate it using my date field ?

Thanks in advance

Re: Create calendar in qliksense

Or — Tue, 22 Mar 2022 15:12:39 GMT

The Week() function takes parameters for both which day is the first of the week, whether broken weeks should be allowed, and which day defines the first week of the year. You should be able to combine these to get what you want, hopefully. If you can't, you can always define your dates and week numbers in an external file (e.g. Excel) and load those in your script.

Re: Create calendar in qliksense

Aspiring_Developer — Tue, 22 Mar 2022 15:15:41 GMT

Hello @Or

Thanks for your response.

I want to do it using external file and use index number but I don't know how to do it 😕

Re: Create calendar in qliksense

Or — Tue, 22 Mar 2022 15:23:23 GMT

I don't know what 'index number' means in this context...

The file would have a structure of e.g.

Date, Week

01/01/2022, 1

02/01/2022, 1

03/01/2022,2

ad infinitum. You would join this to whatever date field you want.

Re: Create calendar in qliksense

Aspiring_Developer — Wed, 23 Mar 2022 10:18:42 GMT

Hi @Or

But I have the data for 5 years, so that means i will have to manually input all the dates for last 5 years in excel and do markings for week start and week end .

Is there any other way out for this ?

Thanks in advance

Re: Create calendar in qliksense

Or — Wed, 23 Mar 2022 11:11:41 GMT

You could use the Week() function with its parameters if you can make that fit your requirement. Since your requirement isn't clear to me, I can't suggest the specific syntax.