Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to create Week in Calendar

Dear Friends,

    I am new in QV world. My requirement is. I want to Create a calendar like

Month starts from April to March

Quarter starts from Apr 1st to March end

The main challenge I am facing is to create the week

I.e., The requirement is my 1st week will starts from Apr 1st sunday onwards. Means In Calendar week which date will coming on 1st sunday my calendar week will starts from that date.

Fro Eg: In Apr 5th is the 1st sunday of the financial year so my 1st week will starts from 5th onwards.

Please help me friends. Many Thanks in Advance.

Regards

Pawan

Tags (2)
3 Replies
MVP
MVP

Re: How to create Week in Calendar

hope to understand, see attachment

Re: How to create Week in Calendar

Can you provide some sample data for this calendar.

Employee
Employee

Re: How to create Week in Calendar

This should be possible to define in your master calendar. The following blog posts describe similar problems, and you can probably use some of the formulae:

Fiscal Year

Redefining the Week Start

Redefining the Week Numbers

HIC

Community Browser