Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jblomqvist
Not applicable

Advice needed: How do you handle the need for calender (or multiple calenders) for dates? I am after soft-skill advice as well as technical

Hi all,

I am after some soft-skill advice as well as technical advice on managing multiple dates where one or more calender may be needed.

My questions are the following:

1. How do you go about handling the requirement for multiple dates? When do you know you will need a calender for each date or not? How do you identify this type of thing and what helps you make a decision on which route to take?

I find that a lot of customers are aware of calenders in QlikView but they automatically assume each date field requires a seperate calender.

I find dates quite tricky to handle in QlikView so often get confused myself on which route to take.

2. Let's say you have two date fields in a Fact table, is it a good idea to create two seperate calenders? I know in some cases you do and in others you don't, how do you go about identifying which option to go for? Is it common to have multiple calenders?

3. What are the rules for creating a link table for dates? I am not sure how to create a link table for dates so an example would be good please.

I am looking to be strong in this area so your best advice in these questions and topics would be appreciated

2 Replies
agomes1971
Not applicable

Re: Advice needed: How do you handle the need for calender (or multiple calenders) for dates? I am after soft-skill advice as well as technical

Gysbert_Wassenaar
Not applicable

Re: Advice needed: How do you handle the need for calender (or multiple calenders) for dates? I am after soft-skill advice as well as technical

See this blog post: Canonical Date


talk is cheap, supply exceeds demand