Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
EMCK
Contributor
Contributor

Two different calendar weeks in one dashboards

Hi all,

I need to include two diffenrent types of calendar week in one Dashboard: First the regular calendar from Monday to Sunday, second a markenting calendar from Thusday to Friday. 

In the end I need two textboxes: The first with the regular Calender weeks (1-52) and a second box with the marketing calender weeks (1-52). The user should be able to choose one or the other calendar week type.

 

Does anyone have an idea how to implement that?

 

Thanks a lot and best regrads

Emck

4 Replies
richard_chilvers
Specialist
Specialist

Hi

Can you better explain your Marketing calendar? What do you mean "fromThursday to Friday" ? Do you mean from Friday to Thursday?

EMCK
Contributor
Contributor
Author

Sorry, you're right: The Marketing Calender goes from Friday to Thursday, of course.

richard_chilvers
Specialist
Specialist

Hi

Try using the Week function with a first_week_day parameter.

Usually the default is for Monday to be the first day of the week. If you set first_week_day to 4, the week will start on Friday.

QVCapture.JPG

Your script will be something like :

Dates:

LOAD Date ......;

Regular_Calendar:

LOAD

Date,

Week(Date) AS Regular_Week_No

RESIDENT Dates;

Marketing_Calendar:

LOAD

Date,

Week(Date,4) AS Marketing_Week_No

RESIDENT Dates;

Brett_Bleess
Former Employee
Former Employee

Did Richard's last post solve your issue?  If so, be sure to give him credit by clicking on the Accept as Solution button, and if you are not able to do that, just leave a reply for us letting us know that did help, and we can mark things for you.  Otherwise we will need some further details as to where you are with things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.